Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 05-31-2004, 04:27 AM   #1
Registered: Dec 2002
Location: Cyberspace, address block 212
Distribution: FreeBSD 6.1-RELEASE
Posts: 34

Rep: Reputation: 15
Upgrading MySQL from Windows to Linux

I am going to upgrade my server from Windows to Linux. I have my MySQL databases on Windows and there are hundreds of them. Is there anyway that I can transfer the databse information from my windows server to linux?
Old 05-31-2004, 06:07 AM   #2
Registered: Sep 2003
Distribution: Gentoo, FreeBSD 5.1
Posts: 122

Rep: Reputation: 15
Can you dump you're current database into files and then import them to Linux database? I think it should work that way.
Old 05-31-2004, 09:09 AM   #3
Registered: Dec 2003
Location: Little Rock, AR
Distribution: Fedora Core 2, AIX, HP-UX, Solaris, Whitebox
Posts: 193

Rep: Reputation: 31
Easier way to backup the MySQL DB's is to just tar/zip up the directory stucture they are stored in. Not sure where that is on Windows. On Linux it is usually /var/lib/mysql. All you have to do to move them over to Linux is just untar/unzip them in the previously mentioned spot and fix the permissions. No dumping necessary, though I would still do this for redundancy purposes.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 04:28 PM
upgrading mysql/php,etc from suse linux yast ritzcoder Linux - Software 0 10-26-2005 04:54 AM
Connection of MySql in Linux with Windows mr_bhavesh Programming 3 05-06-2005 03:28 PM
Upgrading to mySQL 4.x on SusE Linux paulsm4 Linux - Software 0 08-04-2004 06:58 PM
Upgrading to Windows XP pro in laptop with Linux saurya_s Linux - Software 1 11-06-2003 02:43 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:44 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration