shaijuelayidath Posted August 30, 2012 Share Posted August 30, 2012 I am new to mysqli am trying to export a database from my phpMyadmin for Wordpress.i am not seeing a Save As option in my page of export. My version is 3.4.5can anybody help me to export and import the database to my host cpanel Link to comment Share on other sites More sharing options...
justsomeguy Posted August 30, 2012 Share Posted August 30, 2012 Export the database using the SQL format, and have it include both structure and data of the tables. You'll get a file that you can upload through the import tab on the other server. You probably have to create the database before uploading the import file to it. Link to comment Share on other sites More sharing options...
shaijuelayidath Posted August 31, 2012 Author Share Posted August 31, 2012 now i exported as SQL formal, but when i importing it in to my server showing the below alert'#1142 - CREATE command denied to user 'C163071_user'@'127.0.0.1' for table 'test' 'What this means ? Link to comment Share on other sites More sharing options...
justsomeguy Posted August 31, 2012 Share Posted August 31, 2012 It means you don't have permission to create a table. Link to comment Share on other sites More sharing options...
shaijuelayidath Posted September 1, 2012 Author Share Posted September 1, 2012 now i given permissions to the user, everything OK now, thank you justsomeguy Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now