Visitor : 106

Read Comments

Backup and Restore MySQL DB

My_SQL Hosting


Note the Following :

1. Commands mentioned below should be executed from command prompt and not from MYSql prompt.

 

How to create a Backup SQL file

1. Open windows command prompt.

2. Change directory to : C:\Program Files\MySQL\MySQL Server 8.0\bin (This is the standard part where MYsql is installed)

3. Run the following Command

mysqldump.exe –e --column-statistics=0 –u[username] -p[password] -h[hostname] [database name] > C:\[filename].sql

 

How to Restore Backup from SQL File

1. Open windows command prompt.

2. Change directory to : C:\Program Files\MySQL\MySQL Server 8.0\bin (This is the standard part where MYsql is installed)

3. Run the following Command

 

mysql –u[user name] -p[password] -h[hostname] [database name] < C:\[filename].sql

 

How to create a Backup SQL Table

mysqldump.exe –e --column-statistics=0 –u[username] -p[password] -h[hostname] [database name] [table name] > C:\[filename].sql

 



Add Comments