| 10:24 pm on Jan 19, 2013 (gmt 0)|
You will need to edit the wp-config.php file so that the db username and password are relevant to your new db. If you are planning to use the old wp-config.php file you will need to update the path. Be careful not to overwrite one with the other, rename the one you will not be using to keep for a reference if needed.
Are you importing your old db? Did you use a new WP install or just paste all the existing files?
| 10:36 pm on Jan 19, 2013 (gmt 0)|
Thanks for the response not2easy:
here's what I've done so far:
FTP down the wp-contents folder from the existing hosting acct
export the mysql db (there is a problem here because this particular wp install has 2 db, none of the 30 other wp sites I've admin-ed or created or managed have 2 db)
open godaddy linux hosting
clean install fresh wp
FTP up the wp-contents dir
import db into phpmyadmin
fails at that point
so.. perusing the old wp-config.php file I see the:
define db user
define db pwd
edit "localhost" to the exact url of the godaddy mysqlserver
all that is as it should be
closer inspection of the wp-config.php and I see these strings:
and so on... I realized that if the db is looking for those specific values.. they aren't gonna be found on the fresh wp-config.php file on the new hosting acct
might that be where it's failing?
| 11:54 pm on Jan 19, 2013 (gmt 0)|
Using the export / import tool for moving files is a much better option.
| 2:47 am on Jan 20, 2013 (gmt 0)|
You lost me at godaddy, sorry. I don't go there. I have helped people move off godaddy, but never on. Try calling the tech support for help.
| 2:19 pm on Jan 23, 2013 (gmt 0)|
What exactly isn't working? Is there an error or what do you see?
| 10:30 pm on Jan 31, 2013 (gmt 0)|
the best way is to use wordpress exporter plugin.. easy and quick.. and you don't lose any data...
| 11:09 pm on Jan 31, 2013 (gmt 0)|
I took your position re: Godaddy = no good into consideration and got a hosting acct at InMotion Hosting
there is something awry with the db on the existing site (hosted on Site5 hosting)
When I d/l a .gz copy of the db and unzipped it (extracted) using both 7zip and another attempt using PeaZip
I spotted an error msg telling me 2 files did not extract
I am unsure as to why this db refuses to import on either Godaddy or InMotion hosting but does indeed work (albeit loads excruciatingly slow) on site5 hosting
| 2:13 pm on Feb 1, 2013 (gmt 0)|
RE: Database export/import. Have you tried using PHPMyAdmin to do the export? You can probably leave the default settings and just export the database to a file and you'd be good to go.
RE: Speed Issues. Have you optimized the db? Have you looked into how many calls your WP installation makes to the db when loading a page?
| 6:10 am on Feb 10, 2013 (gmt 0)|
I found a workaround by installing onlinewp backup plugin, and importing that into the destination web hosting acct.
To answer your question, lorax, as yet I don't know how to optimize the db, installing the p3 plugin profiler plugin I can see scan results depicting 120 mysql calls (is that too many?)