importing to MySQL

[swrpg]

i have a mysql database on my computer and need to know how to upload it to my x10hosting account.

 

[Cynical]

You can do this easily using phpMyAdmin in cPanel: Just click on the phpMyAdmin icon on your cPanel home page, then click "Import" MyAdmin's homepage. The rest of the directions are on that page .

 

[3aKaT]

you may use it
its the best(IMHO)

 

[swrpg]

using phpMyAdmin doesn't work because,
MySQL said:

#1044 - Access denied for user 'swrpg'@'localhost' to database 'swrpg_samuraiwarrior'

and what does dumper do?

 

[3aKaT]

It is a PHP-script, it is possible to create simply and quickly a backup copy (backup, dump) databases MySQL, and also to restore in case of need a database from a backup copy.
HOW TO (Translated Text)
Installation
1. to unpack zip- file.
2. upload dumper.php into one of the catalogs of your server (accessible from web).
3. to establish for this catalog CHMOD 777.

Use
1. to open in browser URL of the form: http://domain.com/dumper.php.
2. login and password for your database.
3. creation of reserve copy database:

1. select the data base in the upper division of main page.
2. filter leave empty (they will dump all tables selected database), in more detail about the filters see below.
3. select the method of compression (bzip2 the most effective, but also slowest).
4. select compression ratio (as showed the practice, most optimum - 7).
5. press to use.
6. after the end of the work of the script (they will become active button To download file and to return), it is possible download file on http (preliminarily possibly it will be required to dispose the interception of the expansions of .gz and..bz2 in the managers of load) or download on FTP. the name of file consists of the name base of data, and also date and time of the creation of dump, for simplification in the work with the files of reserve copies.

4. restoration database from the reserve copy:
1. select the data base in the lower division of main page.
2. select file from the revealed list. If it is necessary, then preliminarily shake the files of reserve copies into folder backup.
3. press to use.
4. now only it remains to control the process of reduction database.

 

[3aKaT]

using phpMyAdmin doesn't work because,
MySQL said:

#1044 - Access denied for user 'swrpg'@'localhost' to database 'swrpg_samuraiwarrior'

about error #1044
see this http://www.faqts.com/knowledge_base/view.phtml/aid/35227