Trying to upgrade database from 4 to 5.5

Web hosting discussion, programming, and shared and dedicated servers.
8 posts Page 1 of 1
by Pete » Mon Sep 12, 2011 10:40 am
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!!!
by darnold » Tue Sep 13, 2011 4:22 pm
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!
__
Sonic.net Technical Support
707-547-3400
by darnold » Tue Sep 13, 2011 4:23 pm
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. :D
__
Sonic.net Technical Support
707-547-3400
by execfit » Mon Sep 26, 2011 11:06 am
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!
by augie » Wed Sep 28, 2011 4:48 pm
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
by Guest » Thu Sep 29, 2011 12:01 pm
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.... :-/
by augie » Fri Sep 30, 2011 4:31 pm
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
by rachin » Sat Oct 29, 2011 2:44 am
thank a lot . I have same problem but it work.
8 posts Page 1 of 1

Who is online

In total there are 25 users online :: 0 registered, 0 hidden and 25 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: No registered users and 25 guests