dbbackup and restoration

[leoharsh]

hi...I installed presta shop on one of my subdomains n made changes to it. For production use, we installed presta shop on another domain. I took d backup of the subdomain version and tried to restore the database in new domain version but getting the error

"/* Scheme for table ps_access */ CREATETABLE`ps_access` (

`id_profile` int( 10)unsigned NOTNULL ,

`id_tab` int( 10)unsigned NOTNULL ,

`view` int( 11)NOTNULL ,

`add` int( 11)NOTNULL ,

`edit` int( 11)NOTNULL ,

`delete` int( 11)NOTNULL ,

PRIMARYKEY (`id_profile` ,`id_tab`)

) ENGINE= InnoDBDEFAULT CHARSET= utf8;

 

 

MySQL said:

#1046 - No database selected"

 

could anyone help me? any other alernate to it??

[phrasespot]

#1046 - No database selected

That is the problem. Before the import, issue a USE db command to MySQL, replacing db with the relevant db name the import is being done into. For future reference, you can make sure that statement is added to backup by selecting the relevant backup options in backup screen of phpMyAdmin or similar.