>>>>> "Marc" == Marc Santhoff <[EMAIL PROTECTED]> writes:
Marc> Have you tried accessing the old databases from the
Marc> commandline client? Maybe there is a problem with mysql, in
Marc> that case dumping and restoring the database to and from a
Marc> text file with the mysql-tools could help...
Marc> man page for "mysqldump" says:
Marc> ...
Marc> The most normal use of mysqldump is probably for making a backup
Marc> of whole databases. See Mysql Manual section 21.2 Database Back-
Marc> ups.
Marc> mysqldump --opt database > backup-file.sql
Marc> You can read this back into MySQL with:
Marc> mysql database < backup-file.sql
Marc> or
Marc> mysql -e 'source /patch-to-backup/backup-file.sql' database
Marc> However, it's also very useful to populate another MySQL server
Marc> with information from a database:
Marc> mysqldump --opt database | mysql --host=remote-host -C database
Marc> ...
Thanks very much for that information. Right now for reasons unknown to me
mysql -utest
Returns
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (111)
What a frustration!!!!
Uwe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
