using phpMyAdmin to backup my database I select the database I want to back up.
I checked Structure,and under Structure
Add DROP TABLE,
Add IF NOT EXISTS,
Add AUTO_INCREMENT value,
ENCLOSE table and field names with backquotes
I checked Data, and under Data,
Use hexadecimal for binary fields,
Export type was INSERT
I checked Save as File
Under Compression I selected none.
Hit Go and downloaded the file.
At my old host I had shell access and used MySQL commands so please tell me if this formula I used is proper as it is a new experience to use phpMYAdmin.
Another question I have is on the home page under Create new databases it has in red "X No Priviledges", but below that if I click on Databases it seems I can create a new one as the option is there. Am I missing something here? Thanks for any help. By the way I did searches, but I'm mostly interested in if this exact series of steps will create a proper database or if I need to add or drop certain options. Again, thanks for any pointers.