For database clients like PhpMyAdmin you can easily import the backup file, and again, create and populate the tables.
You can also do it through the mysql command line:
For an entire database:
Code:
> mysqldump --all database_name > dump.txt
And then on your new database server:
Code:
> mysqladmin create database_name
> mysql database_name < dump.txt
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.