Trying to go live from wamp - can't import (database naming problem?)
Permalink
Hi, there,
I am trying to go live from my local Wamp installation but I think I have a database naming issue.
My VPS requires all databases to be named "accountname_databasename" and on my WAMP side I just have it as "databasename".
I exported the data via phpMyAdmin, but it won't import because it errors out on the database name. (I had to create the database first before I could import it.)
What should I do the make this work? Should I rename it on the local WAMP side and change the config/site.php file to match the one required on the server?
Is this the best way to do it?
THanks a lot,
- Paul
I am trying to go live from my local Wamp installation but I think I have a database naming issue.
My VPS requires all databases to be named "accountname_databasename" and on my WAMP side I just have it as "databasename".
I exported the data via phpMyAdmin, but it won't import because it errors out on the database name. (I had to create the database first before I could import it.)
What should I do the make this work? Should I rename it on the local WAMP side and change the config/site.php file to match the one required on the server?
Is this the best way to do it?
THanks a lot,
- Paul
just comment out that line ... it should start with
CREATE DATABASE
Just add a /* CREATE DATABASE .... */
You may need to change the next line:
USE 'dbname';
to the name of the new database.
You may also run into some Case issues coming from a WAMP MySQL setup.
Good Luck,
Phil