Moving entire database

[Mark Hewitt]

How do I dump the database? I tried mysqldump but it says no such command :(

[wandrer]

[code]

mysqladmin drop <database-name>

[/code]

[Mark Hewitt]

I'm wary of trying that one. Doesn't drop delete too?
I don't want to delete it, just take a copy

[WildWayz]

DO NOT DROP THE DATABASE!

It DOES delete it.

I tested it out on my old host so it killed the files, and it deletes the whole database.

What I done was this (from memory)

I telnetted to the server.

typed...

mysqldump -p -u<youruserid> <yourdbname> > db.data
Enter your password for the database

This backs up your database to db.data

To then import it back into the new database use...

mysql -p -u<youruserid> <yourdbname> < db.data

See this thread for more info

[url]http://www.vbulletin.com/forum/showthread.php?threadid=1688[/url]
[url]http://www.vbulletin.com/forum/showthread.php?threadid=1035[/url]
[url]http://www.vbulletin.com/forum/showthread.php?threadid=973[/url]

[Mark Hewitt]

Is is possible without using mysqldump as all I get is:

[b]
[worldot@host forums]$ mysqldump
bash: mysqldump: command not found
[/b]

:(

[Mark Hewitt]

??

[ey143]

i get a command not found message when i type mysqldump via telnet.

Also, do you leave a gap between the -u and other bits?

[Mark Hewitt]

The hosting account I am using is now next to useless it is so slow. (I don't think it is me causing it though).

I have a new server to move to but can't because I don't know the commands to save and reload the database.

[ey143]

Guys please, this is so frustrating, everyone is coming out with different versions of the solutions.

I have tried all of these suggestions and none of them work. I either get syntax line 1 errors, or it does not know what mysqldump is.

Can we please cut out all the < << .this .that !* and every other damn ascii symbol there is and stick to this.

Assuming my database is called abcd_com and the url of my site with the forums is [url]http://www.mydomain.com/forums[/url] and my user name is Jack and my password is poo how do I know dump the database?

You say make sure you are in the mySQL directory, how do you know when you are in the directory, cos there is no such folder called mySQL.

Please can someone provide a solution as if backing up a database with the above details.

[ey143]

Does anyone agree with me that the [url]http://www.mySQL.com[/url] website is probably the most un-user friendly site there probably is.

They explain everything in geek language and expect you to understand them, and to top it all, they have badly constructed their pages so that it runs on forever.

[Mark Hewitt]

EUREKA!

I've just figured out what the send option in PHPadmin is for :D

[ey143]

?