Page 1 of 1
Trying to upgrade database from 4 to 5.5
Posted: Mon Sep 12, 2011 10:40 am
by Pete
Spoke with Richard (who was great) about upgrading my database to 5.5. The drill is from what I understand:
1. EXPORT from the old database to a file
2. Create a new database from members tools
3. IMPORT old database into new
I've done this several times, but each time I get an error when importing:
Error
SQL query:
--
-- Database: `execfit_wp1`
--
CREATE DATABASE `execfit_wp1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1044 - Access denied for user 'execfit_wp2-all'@'%' to database 'execfit_wp1'
________
In the meantime, we're dead in the water....please help!
THANKS!!!
Re: Trying to upgrade database from 4 to 5.5
Posted: Tue Sep 13, 2011 4:22 pm
by darnold
More than likely, your exported file contains the line:
CREATE DATABASE <database> DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE <database>;
Take this line out of the file and try again, your should be good to go then.
Our database user's do not have permission to create new databases.
By getting rid of that line, it takes care of this problem. Hope this helps, cheers!
Re: Trying to upgrade database from 4 to 5.5
Posted: Tue Sep 13, 2011 4:23 pm
by darnold
darnold wrote:More than likely, your exported file contains the line:
CREATE DATABASE <database> DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE <database>;
Take this line out of the file and try again, your should be good to go then.
Our database user's do not have permission to create new databases.
By getting rid of that line, it takes care of this problem. Hope this helps, cheers!
sorry, didn't really read the included text from the file, I can see that in fact it does have that line. remove the line and you should be good.
Re: Trying to upgrade database from 4 to 5.5
Posted: Mon Sep 26, 2011 11:06 am
by execfit
Thanks for your reply!
So, that worked...but I still can't get my Wordpress working.
I decided to start over, completely from scratch...and even THAT failed! NEw files (latest Wordpress engine), new database (clean), ... still nothing works.
Any ideas before we jump ship?
Here's the site as it stands:
http://santarosastrength.com/index.php
(comes up blank)
Even the admin loads funky:
http://santarosastrength.com/wp-admin/
I've been using this version of Wordpress for months on a different service, and everything works fine.
Let me know! THANKS!
Re: Trying to upgrade database from 4 to 5.5
Posted: Wed Sep 28, 2011 4:48 pm
by augie
Pete wrote:
#1044 - Access denied for user 'execfit_wp2-all'@'%' to database 'execfit_wp1'
You seem to be trying to access the "execfit_wp1" database with the credentials for the "execfit_wp2" database.
You want to connect to your "execfit_wp1" with your "execfit_wp1-all" user and to your "execfit_wp2" database with your "execfit_wp2-all" user.
I hope that helps.
--Augie
Re: Not working with WP
Posted: Thu Sep 29, 2011 12:01 pm
by Guest
Not sure what you mean... my config file is referring to:
execfit_wp2
Because wp1 is an older MyQL Database (4), I had to EXPORT it, and IMPORT it into a new one (wp2 = MySQL 5.5).
Now, I'm just trying to get it working correctly.... here's how I'm hooking into the DB:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'execfit_wp2');
/** MySQL database username */
define('DB_USER', 'execfit_wp2-all');
/** MySQL database password */
define('DB_PASSWORD', 'b8a03ab0');
/** MySQL hostname */
define('DB_HOST', 'execfit-wp2.db.sonic.net');
/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');
/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');
Any ideas?? I really need to get this site up and running again.... :-/
Re: Trying to upgrade database from 4 to 5.5
Posted: Fri Sep 30, 2011 4:31 pm
by augie
I replaced your .htaccess in that directory with just this:
AddHandler php-cgi .php
Action php-cgi /cgi-bin/php5
The original is in the directory as "htaccess".
It looks to be working now.
Check it out, you'll probably also want to change your MySQL password now that you've posted it to the Internet.
--Augie
Re: Trying to upgrade database from 4 to 5.5
Posted: Sat Oct 29, 2011 2:44 am
by rachin
thank a lot . I have same problem but it work.