sscweb
Feb 27 2003, 09:19 PM
I have a client that had created a mysql database on a server, but they are looking to move this to a hosting service, is it possible to have them moved to your hosting service?
Serge
Feb 27 2003, 11:09 PM
Yes it is possible.
First they have to make a dump of mysql database. If their box is Linux or unix based they can do it with the follwing command:
mysqldump -uUSERNAME -pPASSWORD DATABASENAME >database.dump
Then they have to upload file database.dump to our server, create database and load data to the database with the follwing command.
mysql -uUSERNAME2 -pPASSWORD2 DATABASENAME2 <database.dump
The above commands should be run in the shell.