Relocating

[cgryniewicz]

Hey everyone,

I'm trying to more websitebaker. Everything goes well until, I try and move the database. This is the error message I received in phpMyAdmin.

Code:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: 10.6.166.162
-- Generation Time: Oct 26, 2008 at 12:19 AM
-- Server version: 5.0.67
-- PHP Version: 4.4.4
--
-- Database: `webspinners`
--
CREATE DATABASE `webspinners` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'chrisgryniewicz'@'%' to database 'webspinners'

[kweitzel]

Your usercredentials in the config.php are not correct ... the errormessage is quite clear about that:

#1044 - Access denied for user 'chrisgryniewicz'@'%' to database 'webspinners'

cheers

Klaus

[cgryniewicz]

How do I correct this?

[Ruud]

If you move from a local server to a server at a hosting company, you will probably have to use a database provided by the hosting company.

Normally you will receive a database name and a login for that database from your host.

Export your database without the CREATE TABLE option. (default export options always work for me).
When logged in in your new phpadmin (host) the tables will import in the current database.

The new database and login data should then be changed in your config.php on your new server.

Good luck

Ruud

[cgryniewicz]

Hey,

Now I'm getting this error message.

Code:

Error
SQL query:

CREATE DATABASE  `webspinners` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said:

#1044 - Access denied for user 'chrisgryniewicz'@'%' to database 'webspinners'

[Ruud]

That is the same error as in your first post.

Your host will not allow you to create a database. You have (probably)been provided with one, that is the one you should use.

You are exporting the database wrongly.
I assume you start the export from the main phpMyAdmin page.
When you select a database to export, phpMyAdmin will add the CREATE DATABASE command.

The correct way is to select the database first (left frame), and then click the export tab on the top of the page that will be loaded.
Export using default settings. (you can "test export" by not clicking the zip option).
When you look at the exported data it should NOT start with the CREATE DATABASE in the first couple of lines.

Import the same way. Select the database you have received from your host and import using the tab on the top of the page.

Ruud

[cgryniewicz]

I apologize for my ignorance. But I don't see this option. Here is a screen shot.

Thanks,

cgryniewicz

[Ruud]

Just look a few centimeters below..

Ruud

[cgryniewicz]

Still not working

[Ruud]

What you need to accomplish is that there is no CREATE DATABASE line in your exported data.

Ruud

[cgryniewicz]

Ok, what options do I select then? Where do I mark that option? or Can I remove the code manually?

[Ruud]

The correct way is to select the database first (left frame), and then click the export tab on the top of the page that will be loaded.
Export using default settings. (you can "test export" by not clicking the zip option).
When you look at the exported data it should NOT start with the CREATE DATABASE in the first couple of lines.

That should do it. If it doesn't I'm out of options. My exports work like described here.

Ruud