Some Help With phpMyAdmin Please.
 

I am trying to copy ClitPass' database to another domain, so I can play about with scripts without risking buggering up the main database. I assumed I just hit "export" on ClitPass' phpMyAdmin, then "import" on the new domain's phpMyAdmin. However:

"Export" works. I get a text file with a .sql extension that contains the database tables and some stuff I don't understand (but assume the software needs). When I hit "import" in the other domain there is a delay where (I assume) it us uploading the file via web transfer. Then I get the following error message:

What am I doing wrong, and what should I be doing to make it work?

I don't use PhpMyAdmin for dumps and restores.

I log into my server to open up a shell to my server.

To Dump
DUMP

To Restore

Did u export with quick export method?

Most probably you didn't select a Database or your export script doesn't have the create database statement.

also if u want to play around and test modify, new theme.
without having to upload everything or be online

take a look at:

https://www.apachefriends.org/index.html

OK, granted it's been awhile since I have done an export, but if I remember correctly, there are different formats you can export in.

I used to export in every format I could just to cover my ass.

Thanks, I appear to have got it now. Although I also appear to have loaded the database twice, so I have two entries for every link. Not a problem, now I know what I did wrong (or think I know) I guess I can delete the table and reload it.