Database Names

[Nikki]

Hello, I'm sorry if this question has been asked, but I'm quite stressful right now. I plan on moving my domain here ASAP, or as soon and my current host decides to get in gear and get the severs back up. I use about 4 or 5 database, and I was wondering if you can pick the name yourself, or it has yours username attached to it? An example would be user_database. My current host doesn't have that, but they're also using Plesk. Sorry if I sound confusing, it makes since in my head

[TCH-Dick]

All databases are cpanelusername_databasename, same with usernames, cpanelname_dbaseusername.

[Nikki]

Okay thank you I can still move databases over just as easy though, right? The only thing I need to change is the config files?

[TCH-Dick]

Yeah, you should be able to move them easy enough then edit your config to match the changes.

[Lianna]

Just chatted with Nikki. phpMyAdmin is available in Nikki's version of Plesk, so I will put together the steps for creating a dump and post back.

 

For anyone that may have tips and tricks, Nikki is using MT and would like to make that transition as easy as possible. Thanks in Advance!

[Lianna]

Export/Import a database's tables (structure and data) using phpMyAdmin

 

Open phpMyAdmin

On the left, select the db to export

Click Export tab link

In the Export box, click Select All (to select all tables)

Ensure that SQL radio button is selected

Using the default settings for Structure and Data should serve you well

Checked Structure

Not Add 'drop table'

Checked Add AUTO_INCREMENT value

Checked Enclose table and Field names with backquotes

Checked Data

Not Complete and Extended inserts

Check Save as file

File name template: __DB__ (This will name the file the same as the DB name)

Compression: None.

 

Click GO

Select Save when prompted

Select location and save.

 

Then, when you get setup here -

Using Manage MySQL:

Create the Database

Create the user

Create the association between user and DB

 

Open phpMyAdmin and select this new db

Click the SQL tab link

Click Browse

Find the .sql file that you previously saved

Clicked GO

Tra-la. Should import each table, structure and data.

[Nikki]

Firstly, thank you so much, this will dedfinly help me once I get my account on Monday, I hope anyway. Ok, I did run into a problem. Where it says "Checked Add AUTO_INCREMENT value" I couldn't find that anywhere on the page. My other question is about naming it. Since half the db name will be my user name, is it still ok to save these db's now? Or should I wait untill I get my account before saving them so I can save them with my name attached to it? Sorry if I sound confusing, but I gues I am a little still. Thanks for everything thing though

[Lianna]

Nikki,

 

Don't worry about the Auto_Increment piece, not a big deal and you're probably using a different version of phpMyAdmin.

 

Naming the db is no issue. When you import the tables and data, you will have already created a db here. The file's name is irrelevant, but since you have several db's on the old host, it would make it easier to tell the resulting files apart. This is only a default for the file name.

[Nikki]

Thanks so much for your help! I managed to move all my database fine, but I'm still having major problems with MT. I keep getting

>An error occurred while loading data:

syntax error at lib/MT/Util.pm line 327, near "s/]]&(gt|#62);/

I think I might just have to start all the way over. Thanks though for all your support.