Can someone please tell me how to do a Simple Database Backup for MySQL Database on diff host (computer). I am trying to move my database from one host (server) to a new host (server)
Asked
Active
Viewed 337 times
1
-
2have a look at the mysqldump command – bumperbox Dec 05 '12 at 20:27
-
I don't see how to pick a host. – techsjs2012 Dec 05 '12 at 20:30
-
Which MySQL version are you using? – Blaise Swanwick Dec 05 '12 at 20:33
-
good question.. how can I find out – techsjs2012 Dec 05 '12 at 20:38
-
`SHOW VARIABLES LIKE "%version%";` – Blaise Swanwick Dec 05 '12 at 20:39
-
I would also consider this post: http://stackoverflow.com/questions/2989724/how-to-mysqldump-remote-db-from-local-machine – Blaise Swanwick Dec 05 '12 at 20:42
1 Answers
1
If you just need to transfer a database between servers, using phpMyAdmin, you can use Export on the database on the source to generate a .SQL script, and then use Import on the target server to transfer it.
Alternatively, if the database is too big, you could use something like SQLDumper.
SchmitzIT
- 9,227
- 9
- 65
- 92