03-04-2017, 10:04 PM
you have to create a backup of your production database using mysqldump:
mysqldump -u {user} -p {your_db_name} > dbbackup_Ymd.sql
this will create a total dump of your database into the file dbbackup_Ymd.sql
now you can take this file to any other server in the world and recover it there. Basically, create a new database there, with UTF8 charset and then load the dump into it with:
mysql -u {user} -p {new_db_name} < dbbackup_Ymd.sql
So, when I say "copy the database", I mean make a dump of the database and recover it into a new database using the procedure above
keep asking....
mysqldump -u {user} -p {your_db_name} > dbbackup_Ymd.sql
this will create a total dump of your database into the file dbbackup_Ymd.sql
now you can take this file to any other server in the world and recover it there. Basically, create a new database there, with UTF8 charset and then load the dump into it with:
mysql -u {user} -p {new_db_name} < dbbackup_Ymd.sql
So, when I say "copy the database", I mean make a dump of the database and recover it into a new database using the procedure above
keep asking....
Joe
TSolucio
TSolucio