close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How importing a MySQL (.SQL) file to your database

Thread began 3/03/2010 1:38 pm by Bruce | Last modified 3/05/2010 11:53 am by Bruce | 1222 views | 8 replies |

Bruce

How importing a MySQL (.SQL) file to your database

Hi,
I follow up the "Importing MySQL (.SQL) file to your database" pdf document. I already did this step:
Copying the SQL script
1.On your computer, navigate to the .sql file you intend to import to your database.
2.Open the .sql file in a regular text editor such as Notepad or TextEdit.
3.Select all the content by pressing Ctrl (Cmd) + A.
4.Copy the content by pressing Ctrl (Cmd) + C.
5.Close your text editor application.

My question is about the next step:
Executing the script
6.In phpMyAdmin, choose the database you intend to work with from the Database menu list.


Please select a database.

Question:

There are 3 different databases (information_schema (28), mysql (31), test (8) in the phpMyAdmin page. Which one should I select?
See the snap shot.
Thank you in advance.

Sign in to reply to this post

Jimmy Wu

You should use whichever database you are using to store information for your store. If you haven't set up a database for that you might want to create a new database for this before importing.

Sign in to reply to this post

Bruce

Hi Jimmy,
Thanks for your reply.
Actually this is my first time dealing with MySQL database and I am new to these things. I only follow up the "How to import a MySQL (.SQL) file to your database" pdf document from WebAssist.

  If you haven't set up a database for that you might want to create a new database for this before importing.  


Could you please guide me how to create a new database?
Your fast reply is greatly appreciated because I have to finish this project as soon as possible.
Thanks.

Sign in to reply to this post

Office Guy-172461

The databases in your image are used to manage mysql and should not be used. The test database is a default and can be used for testing.

You should add you own first. Don't get fancy with the name and avoid spaces and special characters. Some hosts limit the number of databases you can create.

Have a look here:

Exporting and Importing a database using phpMyAdmin
150/

Sign in to reply to this post

Bruce

Thanks for the link but it didn't help me how to create a new database.
As I mentioned in my first post (above) I am already following up the "How to import a MySQL (.SQL) file to your database" pdf document from WebAssist.

My concern and question ,as I mentioned in my above post is:
How to create a new database?
Thank you .

Sign in to reply to this post

mr hankey

hi bruce,

you would choose the database in control panel when you create the database. so it will normally ask for database name which myabe also the username and password.

then once you are logged into the database import your .sql file

if you select say test database that you have in the picture you sent it has tables in it by the looks of it so you would want a blank database.

once in your blank database choose import, browse to the sql file and select go

schema is the setup of mysql database so you do not choose that.

thanks

Sign in to reply to this post

Office Guy-172461

Originally Said By: Bruce
  Thanks for the link but it didn't help me how to create a new database.
As I mentioned in my first post (above) I am already following up the "How to import a MySQL (.SQL) file to your database" pdf document from WebAssist.

My concern and question ,as I mentioned in my above post is:
How to create a new database?
Thank you .  



If you had clicked the link to the video tutorial you would have seen how to create a database in the first 20 seconds of the video. If you are already following the pdf and that's telling you what you need. why did you ask for help? If you are not even willing to read my advice then I'm just wasting my time. Wait until the WA guys return and you can ask them.

Sign in to reply to this post

Eric Mittman

I'm not sure if you ever got past this part but in my phpMyAdmin if I choose the databases tab there is an option at the bottom of the page to create a new db. You can also do this with some sql like this:

CREATE DATABASE database_name

Sign in to reply to this post

Bruce

Dear Mr. Office Guy-172461,
WebAssist Community Expert
Before I begin to tell you how unprofessional you sound in your response, I must tell you that I did review the video and it was inadequate for someone like me who is new to the concept.

In your response, you have also mentioned if I was following the PDF document from Webassist, why did I ask you for help. Just so you will know in the PDF document of Webassist, there is no mention of how to create a data base. At least nowhere that I can see!

You have also stated that “if I am not willing to read your advice that you are wasting my time”. Well, when I ran into the first problem while using WebAssist, I did not stop and say that I wasted my money. I must tell your way of communicating with the clients is the ways of a frustrated person who does not like to help people.
Dear Office Guy-172461, if you do not like to assist those of us who need help then you are in the wrong business.


Dear Mr. Mittman,
Thank you for your professional assistance. It helped me a great deal and I was able to create a new database and import .sql file from WebAssist into a new blank database. I will need your help for the next few steps.


Dear Mr. Hankey,
Thanks for your response. It was helpful.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...