BigDump Problems

Recently I have changed webhosts and I'm using BigDump: Staggered MySQL Dump Importer to help me upload my Wordpress database onto my new host.

Unfortunately I keep encountering this error :

This instuction comes with the BigDump:

My dumpfile is encoded in latin1

CREATE DATABASE `silverfl_wp_1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

and I have altered the charset values of the database I am uploading my dumpfile onto to

ALTER DATABASE silverfl_wp
DEFAULT CHARACTER SET latin1
DEFAULT COLLATE latin1_swedish_ci

and I have also edited the file bigdump.php itself

$db_connection_charset = 'latin1';

also my default charset/connection collation values on mySQl are

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: latin1_swedish_ci

What is wrong??

Also if you might have noticed, I'm actually having problems with mySQL itself

MySQL: Access denied for user 'silverfl_xxx'@'localhost' to database 'silverfl_wp_1'

I've been reading up all sorts of articles and googling answers but to no avail. Help will be really,truly, much appreciated.

Thanks in advanced!

 

This is the only problem. You need to provide correct mysql username and password.

 

I have assigned silverfl_xxx as a user in database silverfl_wp under MySQL Databases

However in phpMyAdmin this is shown:

# Server: Localhost via UNIX socket
# User: silverfl@localhost

does this make a difference? The user I have defined in bigdump.php is silverfl_xxx

I tried changing it to

$db_server = 'localhost';
$db_name = 'silverfl_wp';
$db_username = 'xxx';

however then I get this error

Where does the problem lie?

Thanks!

 

Are you providing silverfl_xxx as a mysql username or only xxx?

 

Try using this as the user name = silverfl@localhost

Or make sure to give user = silverfl_xxx full permissions to the database in phpmyadmin.

Boulder

 

allaboutgeo:

I added the mySQL user as 'xxx' and database as 'wp' when I created the new db in MySQL Databases

however it registers as

User: silverfl_xxx
Database: silverfl_wp

and under phpMyAdmin it is

# Server: Localhost via UNIX socket
# User: silverfl@localhost

Boulder:

I tired using silverfl as user, however I get this error

Database connection failed due to Access denied for user 'silverfl'@'localhost' to database 'wp'

I think there is something wrong with the permissions

I have assigned user silverfl_xxx with all permissions yet it phpMyAdmin does not seem to register it

Should I try touching the information_schema database in phpMyAdmin?

Under localhost > information_schema > USER_PRIVILEGES

GRANTEE TABLE_CATALOG PRIVILEGE_TYPE IS_GRANTABLE
'silverfl'@'localhost' NULL USAGE NO

Under localhost > information_schema > SCHEMA_PRIVILEGES



is phpmyadmin not registering silverfl_xxx as a user?

Then how do I assign silverfl privileges?

 

If the user and db are showing up as silverfl_xxx and silverfl_wp, then you must have to use silverfl_xxx and silverfl_wp as user and database names.

 

Did you try to use the full user name with the local host part on it as well?

Like this 'silverfl@localhost'

not just 'silverfl' alone but with the @localhost part on the end of user name too?

Most mysql server do not work that way but I have seen some that require the name with the @localhost attached to the name.

Boulder

 

Yup I tried user 'silverfl@localhost' just now and basically I get the same error.


Database connection failed due to Access denied for user 'silverfl@localho'@'localhost' to database 'wp'

I shall go try again later, cause now even my site's down.

...


This just isnt my day.


Anyway. Do you guys know how to edit permissions manually in MySQL? Maybe it will help.

And thank you all very much for your help

 

Use GRANT.

 

Should be able to grant permission right inside from phpmyadmin panel. Are you sure using the right database password?

Boulder