Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Testing Latest Version (error)
#31
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....
Joe
TSolucio
Reply


Messages In This Thread
Testing Latest Version (error) - mweaver - 02-11-2017, 01:58 PM
RE: Testing Latest Version (error) - joebordes - 03-04-2017, 10:04 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)