Am Mittwoch, den 08.06.2005, 20:23 +0000 schrieb Uwe Brauer: > >>>>> "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)
I think you should rtfm. Is the mysql server running on the same machine? Is it running at all? For me it lives on the local net, then this will do: $ mysql -h vogon -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 41 to server version: 3.23.26-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-------------------------+ | Tables_in_test | +-------------------------+ | ... If I'm logged into the server via ssh: $ mysql -umarc Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.26-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> If mysqld itself cannot read the databases you could dump them on the older server and restore on the new one. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
