Mysql

jackster · 02-03-2005, 01:24 AM

I'm a mysql newbie. Here's the situation... We had a bundled version of mySql installed on the server and i didn't like it. So i installed 4.1.9-log on our server and all is good. What i want to know is, can i copy the old database files e.g. /somewhere/oldmysql/var/database_xx_directory to my new datadirectory? I've done this and i can view the database in phpmyadmin, but now phpnuke does like me any more. Should i rather have done a mysqldump than just copy the dir?

Tx

MasterC · 02-03-2005, 01:52 AM

Yeah, a mysqldump databasename > whatever.sql and then a mysqldump databasename < whatever.sql would have been a better way to do it. As long as you've got the old one still, you should be able to get it working that route (drop the new database to re-create with the steps above).

Cool

jackster · 02-03-2005, 02:03 AM

That's all good, but the problem is that the dump should have been done before the installation of mysql 4.1.9. The problem is that they have different data dir. So when i execute that command you gave, it says "mysqldump: Got error: 1049: Unknown database 'Willie' when selecting the database".

??