[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4688: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4690: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4691: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4692: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
The Honest Way Forum • View topic - Moving DB's to new server help needed

Moving DB's to new server help needed

Discuss webmaster issues, website development and resources. Ask questions about website building, coding, SEP/SEO etc here. NO ADS!

Moderators: magnetize, Oosha, ftello, shezz

Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 2:10 pm

Ok, so I'm getting rid of my 1&1 account (they suck) and am trying to copy my db's for WP over to my HG reseller accounts.

I'm having lots of problems trying to accomplish this.

Is there a quick and easy way to copy them over? I am trying to export with gzipped db's and import, but they keep breaking. Am I missing something?

Any help would be appreciated as I know I have done this before, but I have double ear infections and a sinus infection right now and my 1&1 account will be closed tomorrow... :oops:
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby Tel » Wed Oct 08, 2008 3:19 pm

Elliott, I had a major song and dance moving over 50 WP sites (and this forum) to my reseller a few months ago. I didn't find an easy way as some of the blogs were on older versions of WP (that taught me a nasty lesson!) so I ended doing each one manually.

I opened mySQL in phpmyadmin on the old server and exported the database to the screen. Then copied the data into notepad (so I had a live copy), and pasted back into the database on the new server in the mySQL panel there. That way at least all the tables were populated with the right data.

For the blogs on older WP releases, I had to manually edit each database export to remove defunct tables (there were some). That meant losing some data such as category links to posts etc, but at least the main data (posts, comments etc) remained intact.

Did any of that make sense? I've been writing casino articles for the last 8 hours solid and my brain is a bit fried!
Terry

| | |
User avatar
Tel
Site Admin
 
Posts: 2919
Joined: Sun Mar 25, 2007 4:52 am
Location: Spain

Re: Moving DB's to new server help needed

Postby aprilk » Wed Oct 08, 2008 3:26 pm

Personally I don't use phpadmin because I find it a little confusing. Instead a use the backup option that you find on the home page of cPanel and restore the database there. Install WP as usual and then restore the database. It's very simple really. I just transferred my MU blog that way but it didn't work the first time because the file name of the database was different from the original.

Also, make sure you understand that DNS propagation can take a few days, so your blogs might look as if they're broken when they aren't really.
April
aprilk
 
Posts: 220
Joined: Mon Apr 21, 2008 7:09 pm

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 3:36 pm

Terry,

I can understand the brain fried part and I have been using the phpAdmin to export and then import the dbs...one problem I am having is that I can't see the new "live" sites until my DNS refreshes from GoDaddy as they were pointed to 1&1 and I had to change them to HG account. Guess I'll have to wait and keep my fingers crossed.

April,

Good idea on trying that one. Are you using Fantastico to do the WP install and then just restore the db? Right now I am uploading a new WP install to the site and then using phpAdmin to import the db...
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby aprilk » Wed Oct 08, 2008 3:57 pm

April
aprilk
 
Posts: 220
Joined: Mon Apr 21, 2008 7:09 pm

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 4:15 pm

THanks for the help so far, I seem to have them all working so far except for 1 site. I keep getting a database not found error. I have double checked everything and reloaded all of it and still nothing.... :evil: :evil: :evil:
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby Tel » Wed Oct 08, 2008 4:18 pm

Ha! I knew there had to be an easier way, trust me to pick the toughest option!

By the way, as long as MySQL didn't throw out any errors, you should be fine.

Edit: You got in there before I could post this! Sometimes there is one rogue. maybe just delete WP in fantastico and start again (if you've still got a copy of the database backup)
Terry

| | |
User avatar
Tel
Site Admin
 
Posts: 2919
Joined: Sun Mar 25, 2007 4:52 am
Location: Spain

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 4:45 pm

Well, I'm not sure what the hell is going on with this one.

I exported the db from 1&1, gzipped and saved it.

I uploaded all of the WP files for the newest version (same as 1&1 site install). Uploaded the correct wp-config file.

Created a new db, new user and assigned them correctly. Verified the wp-config.php file is correct. uploaded it.

Imported the db into the new one with phpAdmin, shows all tables, etc are there.

Attempt to visit the site, and still get the "error establishing database connection"...I can't tell where it is coming from however, as I thought WP would have more details like "check your wp-config file" or something....
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 5:03 pm

Ok, really getting pissed now...

Completely wiped all of the site from my HG server. Double checked that I had the DNS pointed to it with GoDaddy, verified that the ip address is showing for my HG server for the domain name, so it should be good.

Deleted the site from HG, added it again and reinstalled with Fantastico the base install. Nothing more, nothing less. Didn't mess with anything.

Still getting the "error establishing a database connection"

WTF?

Not sure where to go from here....anyone with any ideas?
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby Tel » Wed Oct 08, 2008 5:10 pm

Now you got me.

Fantastico is supposed to do all the config stuff for you, so its not a case of entering a wrong database name or password or anything. Were they compatible versions of WP? - hang on did the database import ok?
Terry

| | |
User avatar
Tel
Site Admin
 
Posts: 2919
Joined: Sun Mar 25, 2007 4:52 am
Location: Spain

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 5:11 pm

Yeah, they should have been, but even if they are off by a slight version I should still see the base install from fantastico as I haven't tried to update the db or install anything else from the old site...

I wonder if I am missing something on the main server settings or not sure what or why....
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby Tel » Wed Oct 08, 2008 5:13 pm

If you're using the same package in the WHM as other accounts (ie enough disk space etc) and they all worked, this should too. Mm, I'm not much help here, am I :-?
Terry

| | |
User avatar
Tel
Site Admin
 
Posts: 2919
Joined: Sun Mar 25, 2007 4:52 am
Location: Spain

Re: Moving DB's to new server help needed

Postby ejcross » Wed Oct 08, 2008 5:24 pm

I can't figure it out...it won't even let me log in now to the newly installed Cpanel package either...

Time for tech support me thinks... :roll:
|
ejcross
 
Posts: 285
Joined: Mon Apr 21, 2008 3:52 pm
Location: Kentucky

Re: Moving DB's to new server help needed

Postby Tel » Wed Oct 08, 2008 9:00 pm

Sorry, had to go out for a while. Let us know how you get on with tech support, I'd love to know what the solution to the problem is.
Terry

| | |
User avatar
Tel
Site Admin
 
Posts: 2919
Joined: Sun Mar 25, 2007 4:52 am
Location: Spain


Return to Web Development Resources

Who is online

Users browsing this forum: No registered users and 2 guests

cron