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