Re: [cobalt-users] howto import mysql database from raq4 to 550

[Kevin Bonner <keb@xxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

For our raq4's, I've setup manual backups for our mysql databases.  The 
command I use is:

/usr/bin/mysqldump -uroot -p'MYSQL ROOT PASS' -A --opt > /tmp/mysql_backup.sql

To restore/import this to a new server, I would then just copy the saved file 
to the new server, then run on the new server:

mysql < mysql_backup.sql

Doing this will wipe out the permissions table, but if you're running with a 
new install, this shouldn't matter.  If you want to only backup/migrate 
certain tables, remove the -A option from the mysqldump command, and use the 
- --databases option.  See 'mysqldump --help' for the full syntax.

Kevin Bonner

On Sunday 20 July 2003 06:41, Bob Lenaerts wrote:
> Hi,
>
> I've been hacked and going to cmu all sites.
> Now I've tried to cmuexport and import a vsite and users, and that went
> OK.
>
> But this site uses mysql.
> I did everything I must do on the new server, and then via phpmyadmin I
> tried to restore a dump.
>
> allways (and did it with several dumps of other sites) it comes up with
>
>
> MySQL retourneerde: You have an error in your SQL syntax near
> '--------------------------------------------------------- -- Server
> version 3.23' at line 4
>
> but line 4 is :
> --------------------------------------------------------- !!!!
>
> What is wrong ?
> can't I dump mysql databases from a raq4r to a 550 ??
>
> please help me
>
> regards,
>
> Bob
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/GubJ/9i/ml3OBYMRApq1AJ0d4nJGIg6NkQW8cL+irYRbZTPisACfdZJ1
ao36xLK+5EEMyrc8smiwh1w=
=WAM7
-----END PGP SIGNATURE-----