How to Create a File From SQL
When you migrate from one server to another, you should never forget to migrate the database also. Most servers give you a PHPMyAdmin account which can create a backup of your database in a compressed archive or in a decompressed ".SQL" file if you'd like, using its export feature. Your preference might have to depend, though, on what your new server supports. Back up your database regularly so you don't have to build from scratch every time some problem happens.
Other People Are Reading
Instructions
-
-
1
Go to your server's PHPMyAdmin address. Contact the provider if you don't know what address to go to.
-
2
Log in using your PHPMyAdmin username and password. Again, if you don't know these credentials, contact your provider.
-
-
3
Select a database from the left side of the page and then click "Export."
-
4
Select "INSERT" near the bottom where you can select an "export type."
-
5
In the section on the bottom of the page, put a checkmark in the checkbox in the border labeled "Save as file."
-
6
Click "Go" on the bottom of the page.
-
1
