Moving Board, and Safe Mode

[conan]

I'm moving to another server, and my current host uses save mode, so whenever I make a dump on phpmyadmin, I get hundreds of this following message:

"Cannot set time limit in safe mode"

How can I move my database to another server, and dump my current database.

PS. I tried using telnet, and I got an access problem, :( please I need some guidance!

Thanks in Advance!

[werehere]

What do you mean by access problem?

It would be much easier with telnet, so can your host fix it for you?

[MattR]

It was my understanding that all you had to do was shut down, copy the /var/lib/mysql dir (or wherever your mySQL DBs are installed) move it to the other place, and fire it up.


It's just that easy on Sybase. :D:D:D

[werehere]

Originally posted by mrogish
It was my understanding that all you had to do was shut down, copy the /var/lib/mysql dir (or wherever your mySQL DBs are installed) move it to the other place, and fire it up.


It's just that easy on Sybase. :D:D:D

I believe you can do that yes, but unless you have a dedicated server it is unlikely that is allowed. :)

[conan]

Originally posted by werehere
What do you mean by access problem?

It would be much easier with telnet, so can your host fix it for you?

Even though I can login, when I try to execute the dump command it gives me an "Access Denied for user @ localhost to database databasename"

ERROR 1044

Any suggestion?

PS. thanks for the replies guys!

[chrispadfield]

need to supply your mysql password. Are you doing that?

[werehere]

What exactely are you using for your command to dump the database (you can star out the password for us)?

[conan]

Ok I connect to telnet, then connect to mysql, giving my user and pass (from mysql) and execute this command:

"mysqldump --opt database > backup-file.sql"

and I now get a syntax error, could you please tell me what am I doing wrong?

The syntax error msg I get is:

mysql> mysqldump --opt database > backup-db.sql;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump --opt database

PS. I'm using the proper db name on my file, so replace database with the right db name

[Chris Schreiber]

Originally posted by conan
Ok I connect to telnet, then connect to mysql, giving my user and pass (from mysql) and execute this command:

"mysqldump --opt database > backup-file.sql"


Don't connect to MySQL, you should run the mysqldump command right from the command prompt after you telnet into your server. And just put the -u -p parameters on that line


$ mysqldump -uroot -ppassword --opt database > backup-file.sql


-Chris

[conan]

Chris Schreiber
You sir have my deepest respect!

:)

THANK YOU, THANK YOU IT WORKED!

Of course now I feel dumb :(