What do carrying Mysql database from other hosting?

[elenix]

Hi from Ukraine

I have a problem. I want move my site on x10hosting.com from other hosting. But for carrying the database I necessary give her name: elenixx

On x10hosting.com this name is not assigned, to name of the base is added user name: elenix and it is got DB name: elenix_elenixx

I it is necessary DB name: elenixx
I can't do dump database.

Help please! Thanks!

P.S. Sorry for english

 

[lionheart8]

Hi

If it is A SMALL database, this will help. If it is too big, may be someone else needs to help. This is exactly what I did to move a db base yesterday. My db was say, called bingo - I had to rename it myusername_bingo.

I think cpanel does not allow you to call the db only elenixx BUT only elenix_elenixx.

This is what you need to do:

Make sure the db you created on cpanel elenix_elenixx has same username & password as that in your website db connection script and you add your user to db elenixx_elenixx & set the privileges. The db should also be EMPTY, with NO tables. That means you have to look at the website copy on your PC & change the username/PW/dbname in the db script.

Go to your elenixx db on your PC & rename it to elenix_elenixx, then if you want, zip it, so you have elenix_elenixx.zip

Go to phpmyadmin, select the db elenix_elenixx & then click "Import".

On the import page, select elenix_elenixx.zip on your pc & upload it.
If the db is not too big, it will be imported, though you may need to wait several/many minutes. Be patient.

Dont interrupt the upload until you either have the upload/import success message OR a time out error. If it is too big, it will time out (may be after 30 min).
If it is successful, you will get a confirmation & will see the imported tables on the left.

It worked for me. my db was about 8MB & when I zipped it, about 1.5MB ...
Phpmyadmin recognizes zipped sql files & unzips them when importing the db tables.

I hope it helps.

As said, if your DB is very big, may be you have to use another method.

Good luck!

 

[elenix]

Thanks, but my DB found on freemysql.net (freehosting DB). This hosting DB
does not support rename DB.

Can else who that will advise?

 

[Archkronos]

The way cPanel works is vastly different to other panels; and as such, in this enviroment, it must be named username_dbname...

...and as far as I know there is nothing you can do.

 

[Galdhrim]

Hi from Ukraine

I have a problem. I want move my site on x10hosting.com from other hosting. But for carrying the database I necessary give her name: elenixx

On x10hosting.com this name is not assigned, to name of the base is added user name: elenix and it is got DB name: elenix_elenixx

I it is necessary DB name: elenixx
I can't do dump database.

Help please! Thanks!

P.S. Sorry for english

I dont know how you can restore the DB if you cant dump it, but, asuming there is a way to do it, and if it can be done using phpMyAdmin, you can download WAMP, that is a localhost software (it installs mysql, apache and php), you can try to import the DB there (I dont know how, but since you said your problem is the name of the DB...), and then dump it to install here... anyway you will have to fix the DB name in your site, since it seems there is no way to create a DB with the name you need.

WAMP is free to use, (GPL licence), but it is designed to run on ms-windows (newer than win98)
http://www.wampserver.com/en/

 

[lionheart8]

Have you tried contacting your web host and requesting for a copy of your database, in case you cannot get a copy yourself from the control panel of your current account? Surely, any sensible web host should be able to help, as they know for one reason or another, one needs to transfer db data or make a back up!

If that is not possible at all, the only option then is to point the db connection script to freemysql.net so you avoid using the db at x10hosting. ... I dont know whether that is possible at all or at x10hosting. If it is, it might be your only option.

 

[Corey]

Do you have a backup of the DB in a file?