Jump to content

Wamp/phpmyadmin Export


alib_15
 Share

Recommended Posts

Hi. Does anyone know how to export a database from Wamp using phpMyAdmin?When I have tried to do this, it creates an SQL file containing the tables and data. Then when I try to import I get the error message - No Database Selected.So I have to create a database and then import the tables.Is there a way to create one file that includes the database itself?Thanks for any help.Ali

Link to comment
Share on other sites

you have to first create the database to insert the table and data into.then you insert 'use yourdbname;' (without quotes) into the sql file above instructions for creating tables and inserting data.example:use yourdbname;CREATE TABLE `mytable` ( `Descrip` varchar(40) NOT NULL default '',.............blah, blah, blah

Link to comment
Share on other sites

I was using the wrong export button I think ..I used the export button after selecting my database when I should have used the export buttonon the Home page. This creates a SQL file with the line -CREATE DATABASE dbnameAlip.s. I bet I'm not the first ..

Edited by alib_15
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...