A Simple Database Backup for MySQL Database on diff host (computer)

Question

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)

have a look at the mysqldump command

bumperbox
– bumperbox

2012-12-05 20:27:04 +00:00
Commented Dec 5, 2012 at 20:27 — bumperbox
– bumperbox, Commented Dec 5, 2012 at 20:27
I don't see how to pick a host.

techsjs2012
– techsjs2012

2012-12-05 20:30:37 +00:00
Commented Dec 5, 2012 at 20:30 — techsjs2012
– techsjs2012, Commented Dec 5, 2012 at 20:30
Which MySQL version are you using?

Blaise Swanwick
– Blaise Swanwick

2012-12-05 20:33:49 +00:00
Commented Dec 5, 2012 at 20:33 — Blaise Swanwick
– Blaise Swanwick, Commented Dec 5, 2012 at 20:33
good question.. how can I find out

techsjs2012
– techsjs2012

2012-12-05 20:38:01 +00:00
Commented Dec 5, 2012 at 20:38 — techsjs2012
– techsjs2012, Commented Dec 5, 2012 at 20:38
SHOW VARIABLES LIKE "%version%";

Blaise Swanwick
– Blaise Swanwick

2012-12-05 20:39:03 +00:00
Commented Dec 5, 2012 at 20:39 — Blaise Swanwick
– Blaise Swanwick, Commented Dec 5, 2012 at 20:39

SchmitzIT · Accepted Answer · 2012-12-06 08:21:51Z

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.

answered Dec 6, 2012 at 8:21

SchmitzIT

9,74912 gold badges71 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

A Simple Database Backup for MySQL Database on diff host (computer)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related