Jump to content
alib_15

Wamp/phpmyadmin Export

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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

hosting servers create databases for you to use, so you don't have the option to name it yourself. so you have to add 'use thisdatabase'.but if have the option to create and name, Try it!, but place it above 'use database' statement as you have to create before you can use it.

Share this post


Link to post
Share on other sites

thanks I think its all good now-- Database: `abcmaths`--CREATE DATABASE `abcmaths` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;USE `abcmaths`;I appreciate the help.Ali

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...