Moving MySQL DBs from one server to another - GoFuckYourself.com

HQ · 10-01-2002, 10:56 AM

How do I move some MySQL databases from one server to another? Is there a way to copy the files without doing MySQL commands?

DennisS · 10-01-2002, 11:02 AM

yeah you can but ,

you should use mysqldump

something like this

mysqldump -u username -p dbname > database.db

vending_machine · 10-01-2002, 11:10 AM

If it's the same OS version and filesystems on both you can do db transfers without dumping the database. You _have_ to stop the database on both ends though while you're transferring.

Dopy · 10-01-2002, 11:19 AM

http://www.mysql.com/

All you need to know about dumping.

If systems are the same just copy the data files over as already mentioned.

HQ · 10-01-2002, 11:21 AM

The database in question is no longer being changed, but it *is* being access. Also, both servers are the same OS/Webserver, just different versions:

Redhat Linux 6.1 / Apache -> Red Hat Linux 7.2 / Apahce

Babaganoosh · 10-01-2002, 11:40 AM

It depends on the size of your DB. If you have a DB that is small, you may be able to use phpMyAdmin to move the database. Otherwise, you can use phpMyAdmin to export the data (save it as a file), FTP the .sql file to the new server, then log in to the new server and type

/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql

I have done it a few zillion times so if you need some help, drop me a line and I will see what I can do.

HQ · 10-01-2002, 11:48 AM

Armed & Hammered, hit me up on ICQ, it's in my sig.

I do not have phpMyAdmin, I have Webmin. The database is not very big at all, maybe 1 MB in size. Where are these MySQL databases normally kept in Linux?

HQ · 10-01-2002, 12:33 PM

Nevermind, I found them in /var/lib/mysql/. Can't FTP to it, no access. Damn.

PxG · 10-01-2002, 12:47 PM

HQ,
If you don't have command line access, you can find a PHP or CGI script that will do the backup for you. Then simply FTP the backup file out to your new server.

Here is an example, it's a little much though for your needs:
http://geeklog.sourceforge.net/sampl...ackup-database

This is command line PHP, but you can change that easily by removing the first line, etc.

Good luck,

PxG

HQ · 10-01-2002, 05:31 PM

Quote:

Originally posted by PxG
HQ,
If you don't have command line access, you can find a PHP or CGI script that will do the backup for you. Then simply FTP the backup file out to your new server.

Here is an example, it's a little much though for your needs:
http://geeklog.sourceforge.net/sampl...ackup-database

This is command line PHP, but you can change that easily by removing the first line, etc.

Good luck,

PxG

Thanks PxG, but I have command line access. I can get superuse access but I wish I could just FTP to the location to make my life easier. Will a simply copy from one server to the next suffice?

Apollo · 10-01-2002, 05:42 PM

Since you have root access you can simply tar the var/ directory inside mysql and untar it on the new server....as long as the new version of MySQL supports the table type you used to use you should be fine. I use this method regularly for both backups and database duplication

HQ · 10-01-2002, 05:43 PM

Quote:

Originally posted by Apollo
Since you have root access you can simply tar the var/ directory inside mysql and untar it on the new server....as long as the new version of MySQL supports the table type you used to use you should be fine. I use this method regularly for both backups and database duplication

Excellent thanks.

Will I have to shut down mysql first?

HQ · 10-01-2002, 08:48 PM

.: bump :.

Babaganoosh · 10-01-2002, 08:49 PM

http://www.phpmyadmin.net

It's free. Use it to move your DB with ease.

Apollo · 10-01-2002, 08:51 PM

Quote:

Originally posted by HQ

Excellent thanks.

Will I have to shut down mysql first?

No, it doesn't need to be shutdown to do the backup....of course with it not being shutdown you do run the risk of the original and the copy not being in sync if more data is added/updated to the original. But since you're only regurgitating data, you should have no problems

Apollo · 10-01-2002, 08:53 PM

Quote:

Originally posted by Armed & Hammered
http://www.phpmyadmin.net

It's free. Use it to move your DB with ease.

The only problem I have with PHPmyadmin is that it wasn't designed to handle backups of large databases (both backing up and restoring). Not that this couldn't be resolved...heck if I put some effort into it I'm sure I could create a patch for it. But the really large databases that take more than a minute or so to backup will typically cause the browser to time out....it's one of the main reasons I stopped using it for backup purposes since most of my databases are 1GB+ in size.

However, for the average database, PHPmyadmin is a great program to use. Especially if you're not very unix oriented

Edit: Fixed a few grammatical mistakes that made me sound like I was on crack

XXXManager · 10-01-2002, 09:10 PM

Hey HQ.
Its that simple...
1. Shutdown the MySQL server (on both machine). [mysqladmin shutdown]
2. Copy the DB files of the specific Databases/Tables you want to copy to the other server.
3. start the MySQL server again.

Only reservation - Not working on INNODB Tables (for that you will need either to alter the table type or copy it to a duplicate table of type INNODB or do a dump) - but im not sure you are using this.

HQ · 10-02-2002, 05:24 AM

Quote:

Originally posted by Apollo
No, it doesn't need to be shutdown to do the backup....of course with it not being shutdown you do run the risk of the original and the copy not being in sync if more data is added/updated to the original. But since you're only regurgitating data, you should have no problems

What happens if the database is being accessed or updated while I am copying or downloading it?

HQ · 10-02-2002, 05:26 AM

Quote:

Originally posted by Apollo
But the really large databases that take more than a minute or so to backup will typically cause the browser to time out....

Yeah that could be a bad problem. There are fixes for things like that, but I do not know the technicality of them. Webmin does not time out, for example, on mysql queries that take a couple minutes to calculate.

Babaganoosh · 10-02-2002, 05:29 AM

Quote:

Originally posted by Apollo

The only problem I have with PHPmyadmin is that it wasn't designed to handle backups of large databases (both backing up and restoring). Not that this couldn't be resolved...heck if I put some effort into it I'm sure I could create a patch for it. But the really large databases that take more than a minute or so to backup will typically cause the browser to time out....it's one of the main reasons I stopped using it for backup purposes since most of my databases are 1GB+ in size.

However, for the average database, PHPmyadmin is a great program to use. Especially if you're not very unix oriented

Edit: Fixed a few grammatical mistakes that made me sound like I was on crack

That's basically correct. In the newer versions of phpMyAdmin, you can do a dump of the DB and save it as a tar. Granted, you can't import that massive .sql file into phpMyAdmin with any degree of success but it works great for dumping the DB. You'll still need to SSH into the server to import the data and structure to the new DB. I have had years of MySQL experience and I still prefer to use phpMyAdmin over command line.

HQ · 10-02-2002, 05:31 AM

Quote:

Originally posted by XXXManager
Hey HQ.
Its that simple...
1. Shutdown the MySQL server (on both machine). [mysqladmin shutdown]
2. Copy the DB files of the specific Databases/Tables you want to copy to the other server.
3. start the MySQL server again.

Only reservation - Not working on INNODB Tables (for that you will need either to alter the table type or copy it to a duplicate table of type INNODB or do a dump) - but im not sure you are using this.

Yes, I think I will shutdwon mysql, just in case. Then just copy the database files found in /var/lib/mysql/ to /var/lib/mysql/ of the new server? To be sure, in /var/lib/mysql/ in my old server, I see a bunch of directories, wach directory being the name of the database i have. There are also a few .err and .pid files that appear to be useless. Is this true? I also see a mysql.sock file. What is that? Once I go inside the directories of the databases in question, I see .MYD, .MYI, and .frm files named after each of the tables in the databases. Does all this sound proper? Do I just have to copy the directories of the databases I have to copy over and that's it? Or do I have to be concerned with these other files?

Babaganoosh · 10-02-2002, 05:36 AM

Quote:

Originally posted by HQ

Yes, I think I will shutdwon mysql, just in case. Then just copy the database files found in /var/lib/mysql/ to /var/lib/mysql/ of the new server? To be sure, in /var/lib/mysql/ in my old server, I see a bunch of directories, wach directory being the name of the database i have. There are also a few .err and .pid files that appear to be useless. Is this true? I also see a mysql.sock file. What is that? Once I go inside the directories of the databases in question, I see .MYD, .MYI, and .frm files named after each of the tables in the databases. Does all this sound proper? Do I just have to copy the directories of the databases I have to copy over and that's it? Or do I have to be concerned with these other files?

Really man, use phpMyAdmin to dump the database and import it to the new server with the good 'ol command line method I described above. There are WAY too many variables to make the way you described a viable option. You could potentially screw things up to the point that you will need to reinstall MySQL.

HQ · 10-02-2002, 05:42 AM

Is phpMyAdmin secure?

XXXManager · 10-02-2002, 05:58 AM

Why the hell would you like to install something just o move a database from place to place- nontheless a PHP-remote-admin-tool?
HQ: Yes - what you said is correct. Just copy the directories you want to copy including EVERYTHING in it.
Dont need to copy mysql.sock

I dont see what might go so wrong that you will have to reinstall mysql like Armed & Hammered said.
Armed & Hammered - If you care to elaborate...

HQ · 10-02-2002, 06:14 AM

The server is brand new with nothing on it... If I have to reinstall mysql, it would be no big deal. If I have to reinstall mysq in a month's time, once it is in full swing, then that would suck.

Yeah, I would rather not install new software on 2 boxes just to copy directories, if that is all I need to do.

kinkyplace · 10-02-2002, 06:20 AM

I recently moved my DB: I used mysqldump to create a dump SQL file, FTP:ed it to the new server and read it in into my new DB.
One command at each localtion, from command line.

HQ · 10-02-2002, 06:47 AM

Quote:

Originally posted by kinkyplace
I recently moved my DB: I used mysqldump to create a dump SQL file, FTP:ed it to the new server and read it in into my new DB.
One command at each localtion, from command line.

You have to shutdown mysql before running mysqldump, right? What command reads in the dump into the new DB?

Babaganoosh · 10-02-2002, 07:05 AM

/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql

And there is no need to shut down mysql to dump the DB.

HQ · 10-02-2002, 07:15 AM

Quote:

Originally posted by Armed & Hammered
/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql

And there is no need to shut down mysql to dump the DB.

Thanks.

HQ · 10-02-2002, 07:27 AM

Armed & Hammered, hit me on ICQ.

HQ · 10-02-2002, 07:54 AM

Quote:

Originally posted by Armed & Hammered
/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql

And there is no need to shut down mysql to dump the DB.

Please give me an example of how to dump the file.sql with mysqldump command. I am not sure which options to use. Should I use "--add-drop-table"?

I do not want to delete the databases, I just want a perfect copy of them for the new server.

HQ · 10-02-2002, 11:59 AM

When migrating and old mysql database on an old server to a new server should I copy the "mysql" database over too? Or should I just try to manually set that one up the same afterwards?

Juge · 10-02-2002, 12:48 PM

I'd like to know the answer to this last question, as well...

Anyone?

PxG · 10-02-2002, 03:15 PM

Quote:

Originally posted by HQ
When migrating and old mysql database on an old server to a new server should I copy the "mysql" database over too? Or should I just try to manually set that one up the same afterwards?

Let me understand what you're saying: you're asking whether or not you should move the database named "mysql" over to your new server (from the old). You can do that, since the password hashing algorithm is the same from version to version, but you might have problems with permissions and stuff.

In case you didn't know, the mysql db houses all of your user and privilege information. So the users should be OK, everyone will have the same passwords as before, including root. But for things like privileges and such, if you are missing some of the databases that the data in these tables refer to you might have some problems. That's not to say you will, but you have references to things that aren't really there, which is never too good. The other problem is hosts... you might not want the same hosts access to the dbs in your system, etc., but then again maybe everything remains roughly the same for you after the move.

Look, it's not that big of a deal to add some users with privileges, I have always done it manually.

Hope this helps,

PxG

PxG · 10-02-2002, 03:23 PM

Quote:

Originally posted by HQ

Please give me an example of how to dump the file.sql with mysqldump command. I am not sure which options to use. Should I use "--add-drop-table"?

I do not want to delete the databases, I just want a perfect copy of them for the new server.

Ok, here is what you want:

/path/to/mysqldump -u username -p dbname > dbdumpfile.sql

Now you have a dump of the entire database, as of that moment. You don't need to stop your db server, you don't need to reboot or anything like that, just run this command.

Then, SSH to you new server and run mysql:
/path/to/mysql -u root -p
(once logged in and create your db...)
> CREATE DATABASE dbname;

(now create the user you want)
> GRANT all on dbname.* to username@localhost identified by 'passwordhere';

(you can modify the privileges if you dont want to give all)

(now log out and dump your old db in)
> quit
/path/to/mysql -u username -p dbname < dbdumpfile.sql

and presto your db is now in your new mysql.
(note it will always prompt you for a password when doing this.)

If you need more help, just contact us through our URL and we'll
set you up.

PxG

HQ · 10-02-2002, 04:22 PM

Quote:

Originally posted by PxG
Let me understand what you're saying: you're asking whether or not you should move the database named "mysql" over to your new server (from the old). You can do that, since the password hashing algorithm is the same from version to version, but you might have problems with permissions and stuff.

In case you didn't know, the mysql db houses all of your user and privilege information. So the users should be OK, everyone will have the same passwords as before, including root. But for things like privileges and such, if you are missing some of the databases that the data in these tables refer to you might have some problems. That's not to say you will, but you have references to things that aren't really there, which is never too good. The other problem is hosts... you might not want the same hosts access to the dbs in your system, etc., but then again maybe everything remains roughly the same for you after the move.

Look, it's not that big of a deal to add some users with privileges, I have always done it manually.

Hope this helps,

PxG

I think you perfectly understand what I am saying. Every single database and user on the old system has to be transported to the new system, therefore the table named "mysql" should work fine (according to what you say.)

HQ · 10-02-2002, 04:24 PM

Quote:

Originally posted by PxG
Ok, here is what you want:

Thanks PxG, but before I read your post I tar'ed everything up and FTPed it from the old server to my home computer to the new server... all the databases were properly unpacked with proper file permissions and ownerships. So far everything works but I have yet to actually copy the "mysql" database in, I was waiting on that one (because I had to overwrite it, the other ones I did not have to overwrite because the new server is a fresh clean install of mysql.)

Babaganoosh · 10-02-2002, 04:48 PM

One last thing, once you add new users make SURE you reload mysql so the changes can take effect. I can't tell you how many times I have shot myself in the foot because I didn't reload mysql and therefore couldn't get the username to log in to the DB.

salsbury · 10-02-2002, 04:49 PM

also since the database isn't big it doesn't hurt to run a isamchk or myisamchk - won't take much time at all - just to verify that the data is OK.

isamchk *.ISM i think and myisamchk *.MYI

Apollo · 10-02-2002, 04:59 PM

Quote:

Originally posted by HQ

What happens if the database is being accessed or updated while I am copying or downloading it?

Being accessed isn't an issue...if it's being updated than the worst that can happen is your backup will be outdated and not have that new updated information in it...but really that'll be a problem regardless of how you backup the database =)

HQ · 10-02-2002, 05:07 PM

Quote:

Originally posted by Armed & Hammered
One last thing, once you add new users make SURE you reload mysql so the changes can take effect. I can't tell you how many times I have shot myself in the foot because I didn't reload mysql and therefore couldn't get the username to log in to the DB.

How do you reload mysql? Shut it off and turn it back on?

HQ · 10-02-2002, 05:09 PM

Quote:

Originally posted by Apollo

Being accessed isn't an issue...if it's being updated than the worst that can happen is your backup will be outdated and not have that new updated information in it...but really that'll be a problem regardless of how you backup the database =)

Oh yeah, when I tar'ed the whole mysql directory up, I turned off mysql while doing that just to make sure that the files were not being changed as they were being copied. I was not sure if that could even happen, but it was a precaution I took.

HQ · 10-02-2002, 05:10 PM

Quote:

Originally posted by salsbury
also since the database isn't big it doesn't hurt to run a isamchk or myisamchk - won't take much time at all - just to verify that the data is OK.

isamchk *.ISM i think and myisamchk *.MYI

Great, I'll do that... isamchk exists, but not myisamchk... unless it is a mysql command and is not available in linux.

HQ · 10-02-2002, 05:22 PM

salsbury, or any one, what is the difference between *.ISM and *.MYI databases? I noticed that some of my older databases are *.ISM and my newer ones are *.MYI. What is the difference?

HQ · 10-03-2002, 05:32 AM

Bump.

HQ · 10-03-2002, 12:11 PM

I started a new thread on problems with migration the "mysql" database (all others worked). Here it is:
http://www.gofuckyourself.com/showth...threadid=80312

10-01-2002, 10:56 AM	#1
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Moving MySQL DBs from one server to another How do I move some MySQL databases from one server to another? Is there a way to copy the files without doing MySQL commands?

10-01-2002, 11:02 AM	#2
DennisS Confirmed User Join Date: Jan 2002 Location: N.Y.C Posts: 265	yeah you can but , you should use mysqldump something like this mysqldump -u username -p dbname > database.db __________________ Last edited by DennisS; 10-01-2002 at 11:03 AM..

10-01-2002, 11:10 AM	#3
vending_machine Confirmed User Join Date: Jun 2002 Location: Seattle Posts: 1,062	If it's the same OS version and filesystems on both you can do db transfers without dumping the database. You _have_ to stop the database on both ends though while you're transferring. __________________

10-01-2002, 11:40 AM	#6
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	It depends on the size of your DB. If you have a DB that is small, you may be able to use phpMyAdmin to move the database. Otherwise, you can use phpMyAdmin to export the data (save it as a file), FTP the .sql file to the new server, then log in to the new server and type /path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql I have done it a few zillion times so if you need some help, drop me a line and I will see what I can do. __________________ I like pie.

10-01-2002, 12:47 PM	#9
PxG Confirmed User Join Date: Feb 2002 Posts: 105	HQ, If you don't have command line access, you can find a PHP or CGI script that will do the backup for you. Then simply FTP the backup file out to your new server. Here is an example, it's a little much though for your needs: http://geeklog.sourceforge.net/sampl...ackup-database This is command line PHP, but you can change that easily by removing the first line, etc. Good luck, PxG __________________ Kill Password Hackers Now! Kill Hit-Botters Now! _____________________________

10-01-2002, 11:19 AM	#4
Dopy Confirmed User Join Date: Feb 2001 Location: Puerto Del Carmen, Lanzarote, Canary Islands Posts: 1,572	http://www.mysql.com/ All you need to know about dumping. If systems are the same just copy the data files over as already mentioned.

10-01-2002, 11:21 AM	#5
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	The database in question is no longer being changed, but it is being access. Also, both servers are the same OS/Webserver, just different versions: Redhat Linux 6.1 / Apache -> Red Hat Linux 7.2 / Apahce

10-01-2002, 11:48 AM	#7
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Armed & Hammered, hit me up on ICQ, it's in my sig. I do not have phpMyAdmin, I have Webmin. The database is not very big at all, maybe 1 MB in size. Where are these MySQL databases normally kept in Linux?

10-01-2002, 12:33 PM	#8
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Nevermind, I found them in /var/lib/mysql/. Can't FTP to it, no access. Damn.

10-01-2002, 05:42 PM	#11
Apollo Confirmed User Join Date: Sep 2002 Location: Canada Posts: 433	Since you have root access you can simply tar the var/ directory inside mysql and untar it on the new server....as long as the new version of MySQL supports the table type you used to use you should be fine. I use this method regularly for both backups and database duplication __________________ ----------- Free automated way to rotate sponsor gallery thumbnails on your sites TgpWizards - Free TGP Gallery submission system

10-01-2002, 08:48 PM	#13
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	.: bump :.

10-01-2002, 08:49 PM	#14
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	http://www.phpmyadmin.net It's free. Use it to move your DB with ease. __________________ I like pie.

10-01-2002, 09:10 PM	#17
XXXManager So Fucking Banned Join Date: Mar 2002 Location: Far out in the uncharted backwaters of the unfashionable end of the Western Spiral arm of the Galaxy Posts: 893	Hey HQ. Its that simple... 1. Shutdown the MySQL server (on both machine). [mysqladmin shutdown] 2. Copy the DB files of the specific Databases/Tables you want to copy to the other server. 3. start the MySQL server again. Only reservation - Not working on INNODB Tables (for that you will need either to alter the table type or copy it to a duplicate table of type INNODB or do a dump) - but im not sure you are using this.

10-02-2002, 05:42 AM	#23
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Is phpMyAdmin secure?

10-02-2002, 05:58 AM	#24
XXXManager So Fucking Banned Join Date: Mar 2002 Location: Far out in the uncharted backwaters of the unfashionable end of the Western Spiral arm of the Galaxy Posts: 893	Why the hell would you like to install something just o move a database from place to place- nontheless a PHP-remote-admin-tool? HQ: Yes - what you said is correct. Just copy the directories you want to copy including EVERYTHING in it. Dont need to copy mysql.sock I dont see what might go so wrong that you will have to reinstall mysql like Armed & Hammered said. Armed & Hammered - If you care to elaborate...

10-02-2002, 06:14 AM	#25
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	The server is brand new with nothing on it... If I have to reinstall mysql, it would be no big deal. If I have to reinstall mysq in a month's time, once it is in full swing, then that would suck. Yeah, I would rather not install new software on 2 boxes just to copy directories, if that is all I need to do.

10-02-2002, 06:20 AM	#26
kinkyplace Confirmed User Join Date: Mar 2002 Location: Sweden Posts: 217	I recently moved my DB: I used mysqldump to create a dump SQL file, FTP:ed it to the new server and read it in into my new DB. One command at each localtion, from command line.

10-02-2002, 07:05 AM	#28
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql And there is no need to shut down mysql to dump the DB. __________________ I like pie.

10-02-2002, 07:27 AM	#30
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Armed & Hammered, hit me on ICQ.

10-02-2002, 11:59 AM	#32
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	When migrating and old mysql database on an old server to a new server should I copy the "mysql" database over too? Or should I just try to manually set that one up the same afterwards?

10-02-2002, 12:48 PM	#33
Juge Confirmed User Join Date: Feb 2001 Posts: 1,917	I'd like to know the answer to this last question, as well... Anyone?

10-02-2002, 04:48 PM	#38
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	One last thing, once you add new users make SURE you reload mysql so the changes can take effect. I can't tell you how many times I have shot myself in the foot because I didn't reload mysql and therefore couldn't get the username to log in to the DB. __________________ I like pie.

10-02-2002, 04:49 PM	#39
salsbury Confirmed User Join Date: Feb 2002 Location: Seattle Posts: 1,070	also since the database isn't big it doesn't hurt to run a isamchk or myisamchk - won't take much time at all - just to verify that the data is OK. isamchk .ISM i think and myisamchk .MYI __________________

10-02-2002, 05:22 PM	#44
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	salsbury, or any one, what is the difference between .ISM and .MYI databases? I noticed that some of my older databases are .ISM and my newer ones are .MYI. What is the difference?

10-03-2002, 05:32 AM	#45
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	Bump.

10-03-2002, 12:11 PM	#46
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	I started a new thread on problems with migration the "mysql" database (all others worked). Here it is: http://www.gofuckyourself.com/showth...threadid=80312 Last edited by HQ; 10-03-2002 at 12:13 PM..