How To Upload Mysql Db ?

[jojo]

Hi;

I am trying to find out how to upload my mysql DB using Cpanel,

I have a dump of my DB, but i can not find out how to upload it ,

 

the only thing I see in mysql management is to create DB and add user to the DB.

I could not find anything about import or upload of DB in documentaion either.

 

anyone care to explain?

 

thanks a lot

[leezard]

in cpanel scroll to the bottom, right below manage mysql is phpmyadmin, you can upload a db with that.

[TCH-Sales]

You can also go to Backups in CPanel, and restore a database from there as well. Only do this though if your back was created through CPanel, not sure how it would react any other way...

[jojo]

Thanks for reply;

 

I still can not find how to upload it,

on phpmyadmin, I see the dabase that I have created, which is empty of course,

now when I click on it, another page opens up, now I will see an option to make table/s for the opend DB,

 

 

I don't see how to upload my tables of DB which is in SQL format that I got it by dumping my DB.

 

is it so simple that I miss it?

 

is anyone can walk my trough it

I am very greatful.

 

Thanks

[jojo]

I found my way;

 

thanks for all replies

[TCH-Don]

For anyone else wishing to restore a database through

phpMyAdmin in cpanel,

Select the database on the left,

Click on SQL,

in the window at the bottom

Or Location of the textfile :

browse to the backup on your computer,

select go, and give it time.

[jrd]

I keep getting an error message when I try to upload a database.

 

>Database myusername_mydatabasename running on localhost 
Error

SQL-query :  

CREATE DATABASE `myusername_` 

MySQL said: 

Can't create database myusername_'. Database exists
Back

 

(where mydomain is my user name and mydatabasename is my new database name.)