Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Migrating MySql to new host best process?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Panhandler
Average Member

USA
783 Posts

Posted - 16 October 2007 :  23:18:34  Show Profile  Visit Panhandler's Homepage
The plan is to copy all the forum folders and files to the new host server. That's easy enough and already done.

But what's the best process from there?
Should I create a new database and run setup.asp?

Or create a new database and then run SQLyog Enterprise to transfer the existing MySql tables to the new serve database - or how is that best done exactly?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2007 :  04:13:40  Show Profile  Send ruirib a Yahoo! Message
SQLYog will do it all for you. If the Db isn't big, the copy DB option is the easiest. If it's rather big, exporting the db to a SQL script with SQLYog and then importing it to the new DB, again using SQLYog, is the fastest way.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Panhandler
Average Member

USA
783 Posts

Posted - 17 October 2007 :  09:15:03  Show Profile  Visit Panhandler's Homepage
quote:
Originally posted by ruirib

SQLYog will do it all for you. . .

Yes, but should I create a new database first?


"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums


Go to Top of Page

HuwR
Forum Admin

United Kingdom
20593 Posts

Posted - 17 October 2007 :  09:20:40  Show Profile  Visit HuwR's Homepage
yes you will need to have a new db ready and created, but you won't need to have Snitz create all the tables
Go to Top of Page

Panhandler
Average Member

USA
783 Posts

Posted - 17 October 2007 :  10:07:59  Show Profile  Visit Panhandler's Homepage
quote:
Originally posted by HuwR

yes you will need to have a new db ready and created, but you won't need to have Snitz create all the tables


Thanks HuwR. . .I had already set up a new Snitz complete with all the tables.
With nothing to lose I elected to use the "Copy DB to new host" feature of SQLyog. I checked the "drop tables" option and tried it.
Very easy. It worked perfectly.
Thanks Rui and Huw.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2007 :  10:43:23  Show Profile  Send ruirib a Yahoo! Message
Yep, it's very easy. Glad it all went well .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07