29,048
edits
Changes
Migrar en un servicio en la Nube (Cloud) (view source)
Revision as of 22:59, 18 March 2014
, 11 years ago→Step 1 - Backup your old database
Line 22:
Line 22:
+
+
mysqldump -h ip_of_old_mysql_server -P port_of_old_mysql_server -u user_database -ppassword_database > myoldserverdump.YYYYMMDD.sql
mysqldump -h ip_of_old_mysql_server -P port_of_old_mysql_server -u user_database -ppassword_database > myoldserverdump.YYYYMMDD.sql
</source>
</source>
−* Open file myoldserverdump.YYYYMMDD.sql to see if file is complete: File should end with such a line:
+* Open backup file mysqldump_A.B.C_YYYYMMDDHHMMSS.sql to see if file is complete: File should end with such a line:
<source lang="sql">
<source lang="sql">
-- Dump completed on YYYY-MM-DD HH:mm:ss
-- Dump completed on YYYY-MM-DD HH:mm:ss