close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Error Creating BSM Database MySQL

Thread began 10/23/2009 7:47 pm by gregurke385889 | Last modified 10/26/2009 2:58 pm by Eric Mittman | 895 views | 2 replies |

gregurke385889

Error Creating BSM Database MySQL

Page 13 of the eCart Tutorial "To create the sample MySQL database"

The explanation for mac asks to use terminal. Tried it to the letter numerous times, didn't work. I am using MAMP now and have only just recently finished the PHP starter kit so am new to all this dynamic stuff (static web/graphic designer)

Anyway with MAMP running the MySQL Server I can go into MySQL admin and try and create the database form there right?

I copied the blue_sky_music.sql file to the Documents folder as directed, and went to create new database/schema but it gave me an error message. I then tried "restoring" the .sql file instead. I have attached (picture 1 ) to show the error message I keep getting after trying a number of times. (tried turning MAMP off, have run a diagnostic to repair permissions on the HD you name it.)

With MAMP I tried using MySQL Lite to create the db and it seemed to work although it won't sow up in MySQL Admin so I can follow the steps to add the table content.

Sorry if any of the above shows I have no idea, but I just want to push on.

Help!

DG

Sign in to reply to this post

Office Guy-172461

I'm at a disadvantage here because I don't do Mac or MAMP but:

1. The .sql file is what's called a SQL dump file. It is just a text file full of SQL instructions that you can view in a text editor. It works the same as if you typed them in by hand.

2. You can run those instructions to create the database for you by importing or "run a batch file" depending on what program you are using (Not that you would want to).

Have a look here:
Exporting and Importing a database using phpMyAdmin
150/

phpMyAdmin comes pre-installed with most hosts.

Sign in to reply to this post

Eric Mittman

One way that I create db's from backups like this is to create the db myself from either the command line or a GUI tool. Then when I have this empty db opened I just cut and paste the sql from the file into a query window and execute all the statements. It is probably worth getting phpMyAdmin installed if you are having a hard time with your current GUI tool. Another good tool for the Mac is sequel pro.

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...