| Author |
 Topic  |
|
|
mahvin
Starting Member
48 Posts |
 Posted - 08 February 2008 : 01:08:55
|
I am trying to move a 25meg MySQL database from an expiring GoDaddy site (Windows hosted) to a new GoDaddy site (Windows hosted). phpAdmin only allows for 2meg files. I have queried here and the Internet trying to find a simple way to do it. My friends suggest that GoDaddy move the file since its staying within the hosting service. I would appreciate any help, if anybody knows a way to do this and keep the database intact.
mahvin |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 08 February 2008 : 04:40:07
|
quote:
Originally posted by mahvin
My friends suggest that GoDaddy move the file since its staying within the hosting service.
That's the way to do it, alright.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
Graycode
Starting Member
7 Posts |
|
|
mahvin
Starting Member
48 Posts |
Posted - 08 February 2008 : 20:24:29
|
| This requires purchasing the SQLyog hosting package, from my understanding it only applies to the Linux hosted sites. I am really confused by all this, being that Snitz runs on ASP/Windows hosted sites, and no one seems to know the alternatives to this. I get all kinds of suggestions from everyone, and they all seem to lead to a dead end. Seeing that I am dealing with a large non-profit organization, and the database is very extensive and necessary to keep, starting from scratch is not really an option. |
|
|
|
mahvin
Starting Member
48 Posts |
Posted - 08 February 2008 : 21:41:07
|
I figured a way around it, thought I might share this information here:
1.First I went to the old site and did a backup of the database in question.
2.After getting the "backup successful" msg from godaddy, I went to the new site, via ftp, and downloaded the database from the _db_backups folder onto my hard drive
3.I then accessed the new site, via FTP, and uploaded the same database into the _db_backups folder there(larges file will take awhile, be prepared to wait it out, even with broadband connection - 10 minutes). Closed connection when done.
4.Logged into the new site via web, accessed the MySQL databases and used restore, selected the database I just uploaded, and away it went. Just now checking the tables, they all seem intact. I have not set up the new snitz forum yet.
Any advice or warnings I need to be aware of? Fingers crossed, hope it works.
|
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 09 February 2008 : 08:27:24
|
The only thing I would advise is to check your connection string in config.asp.
You'll want to make the change if your server IP is different.
If your URL for the forum has changed, you'll need to go into Admin Options and make the change in Main Forum Configuration.
Other than that, I can't think of anything else you need to check.
|
|
|
| |
Topic |
|
Topic Locked
