Results 1 to 6 of 6
-
06-16-2005, 05:26 PM #1Junior Guru Wannabe
- Join Date
- Mar 2005
- Posts
- 94
Moving MySQL DB Help... Please :(
Hello again folks.
I have a problem... basically Im in the process of moving all my sites from 1 server to another. The enviroments that the site(s) are moving to/from are pretty much identicle.
OS: Windows 2003
Now... basically the problem Im having is moving the sites running from a MySQL database. I need to know howto move the database(s) over from the old server to the new server.
Please dont think im coming here as an easy option as I have looked into this but cant find a solution that works for me as I cant use phpmyadmin - Nor am I using cPanel.
Is there anyway I can just move the directory storing the db files onto the new server? Basically Im open to pretty much all and any options providing theyre not using a control panel backup feature nor using phpmyadmin or similar.
Thanks for your time.
-
06-16-2005, 05:49 PM #2Junior Guru Wannabe
- Join Date
- Jul 2003
- Location
- Missouri
- Posts
- 30
http://www.ozarkhost.com/forum/viewtopic.php?t=15
This was a linux howto but should apply to windows server as well.
-
06-16-2005, 06:04 PM #3Junior Guru Wannabe
- Join Date
- Mar 2005
- Posts
- 94
So are they commands I need to put in the DOS prompt?
-
06-16-2005, 06:09 PM #4Engineer
- Join Date
- Jan 2005
- Location
- Scotland, UK
- Posts
- 2,681
Hello,
Yes, I created this guide. http://www.hostgeekz.com/guides/Othe...l_database.htm
The majority of it will work with dos prompt with some slight changes.Server Management - AdminGeekZ.com
Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
Check our wordpress varnish plugin. Contact us for quote: sales@admingeekz.com
-
06-16-2005, 10:33 PM #5Junior Guru
- Join Date
- Sep 2004
- Location
- Chicago, IL
- Posts
- 214
Is this a live site; regardless of how, there will be some downtime involved to prevent data loss.
-
06-17-2005, 12:48 AM #6Junior Guru Wannabe
- Join Date
- Mar 2005
- Posts
- 94
Downtime isnt really a problem, im fine with that - its just the moving DB's over.
HostGeekZ - what changes would be needed?