Can't do anything with MySql!

[Webspanner]

Please excuse a newbie question, but how am I supposed to use MySQL? I can't create a data with phpMyAdmin, because it says I'm not authorized. Well if I'm not, who the heck is? If somebody could point me in the direction of some GOOD documentation MySQL, I'd appreciate it...

[felgall]

Look in cPanel at where you found the phpmyadmin link and you will see two icons immediately to the left of it. Those provide two different ways for you to create a database. The wizard option takes you through all the steps required one after the other.

[Webspanner]

Look in cPanel at where you found the phpmyadmin link and you will see two icons immediately to the left of it. Those provide two different ways for you to create a database. The wizard option takes you through all the steps required one after the other.

Thanks, that does work. But is it possible to upload a database via FTP? I've got such nice tools at home, but they refuse to open the database on my site.

[felgall]

You can't upload a database via FTP since you don't have access to where the database files are store other than via mysql calls.

The easiest way to upload a database once you have created it is to use the import tab in phpmyadmin and reference the file on your computer with the database content from there. It will then upload the file and run all the sql commands your file contains to create the database content.

The easiest way to create the file that the import can read is to use the export tab from phpmyadmin on the computer where the database was previously running. Alternatively if you have command line access you can dump the database into a file.