| View previous topic :: View next topic |
| Author |
Message |
thecooptoo
Veteran
Joined: 27 Apr 2003
Posts: 1353
Location: UK
|
 Posted: Sat Nov 20, 2004 11:41 am Post subject: moving myswl databse between windows and linux |
 |
|
i ve got a Mysql app DB that i am writing at work (win2000). I want to work on it at home as well. For confidentiality reasons i can tsend information over the internet, so configuring it to use i DB isnt on.
I can copy all the windows files to a usbstick and then copy them into /var/lib/mysql/db
chown everyhing to mysql:mysql adn change the case of the suffixes.
phpmyadmin finds the database but then says there are no rows in any of the tables.
Anyone know what Im missing ? |
|
| Back to top |
|
 |
jeremy whiting
Apprentice
Joined: 25 May 2004
Posts: 159
Location: UT
|
| Posted: Sat Nov 20, 2004 2:12 pm Post subject: |
|
|
the easiest way to copy a mysql database is to do a
| Code: | | mysqldump yourdatabasename > myfile |
then do a
| Code: | | mysql databaseathomename < myfile |
once you copy the dumped file to the computer at home.
that way you don't have to worry about any of mysql's files itself, plus it's fast. |
|
| Back to top |
|
|
NewBlackDak
Guru
Joined: 02 Nov 2003
Posts: 512
Location: Utah County, UT
|
| Posted: Sat Nov 20, 2004 4:19 pm Post subject: |
|
|
You also need to get th emysql table, so all permissions will be the same.
_________________
Gentoo systems.
X2 4200+@2.6 - Athy
X2 3600+ - Myth
UltraSparc5 440 - sparcy |
|
| Back to top |
|
|
|
Other Things Gentoo
