469,613 Members | 1,300 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

Move a MySQL Database to another system

I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #1
4 5207
spyros

Well I just did pretty much the opposite. From Linux to XP. Take a look at
mySQLDump. I don't have the exact syntax in front of me, but I dumped out
the database into a .SQL. This contains both the SQL to create the tables
and the data. Then on the target machine I created the new database:

C:\mysql\bin\mysqladmin create xyz -u root

Where xyz was the name of the database I wanted to create.

Then I imported the attached file using something like

C:\mysql\bin\mysql xyz < xyz.sql -u root

You'll have to look up the mySQLdump documentation (you can dump the entire
DB or just certain tables) and of course where I've used a DOS path yours
will be something like /mysql/bin/<whatever>

HTH

Rob
"Spyros" <sp*******@netscape.net> wrote in message
news:4r********************************@4ax.com...
I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #2
spyros

Well I just did pretty much the opposite. From Linux to XP. Take a look at
mySQLDump. I don't have the exact syntax in front of me, but I dumped out
the database into a .SQL. This contains both the SQL to create the tables
and the data. Then on the target machine I created the new database:

C:\mysql\bin\mysqladmin create xyz -u root

Where xyz was the name of the database I wanted to create.

Then I imported the attached file using something like

C:\mysql\bin\mysql xyz < xyz.sql -u root

You'll have to look up the mySQLdump documentation (you can dump the entire
DB or just certain tables) and of course where I've used a DOS path yours
will be something like /mysql/bin/<whatever>

HTH

Rob
"Spyros" <sp*******@netscape.net> wrote in message
news:4r********************************@4ax.com...
I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros

Jul 19 '05 #3
When I have to copy files from one system to another linux-win
win-linux or whatever I use the net to store a copy and download on to
the different system.
On Thu, 25 Sep 2003 12:06:38 +0300, Spyros <sp*******@netscape.net>
wrote:
I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros


Jul 19 '05 #4
When I have to copy files from one system to another linux-win
win-linux or whatever I use the net to store a copy and download on to
the different system.
On Thu, 25 Sep 2003 12:06:38 +0300, Spyros <sp*******@netscape.net>
wrote:
I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000
Server to a 4.0.14-max on a Redhat Linux Server.
Any idea will be welcome.
Thanks
Spyros


Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Spyros | last post: by
reply views Thread by Mike Chirico | last post: by
17 posts views Thread by chicha | last post: by
13 posts views Thread by Jim Hubbard | last post: by
Atli
6 posts views Thread by Atli | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.