MySQL Forums
Forum List  »  Newbie

Re: Install and Import a data base
Posted by: victor chapman
Date: June 11, 2014 05:39PM

Rick James Wrote:
-------------------------------------------------------
Let me thank you for providing this information. I am still trying to work through and digest all of this.


> WAMP is a nice package that installs MySQL, PHP,
> Perl, and Apache. There are other packages like
> WAMP. You can ignore PHP, etc., and simply use
> MySQL.
>
> The install will be good enough to get started
> with.
>
> Find the "commandline mysql" and use it for many
> things. Or find phpmyadmin, which is a nice UI.
>
> C:\? mysql
> mysql> source foobar.sql
> mysql> exit
>

This works although it requires that you load a database first. This took me a while to figure out. Once I loaded the "test" database I was able to use my .sql file as the source.

I have posted a few inquiries and I impressed by its speed.

How do I save my working environment so that the next time I don't have to reload everything or does that happen automatically?


> You will now have the .sql file loaded (assuming
> it is called foobar.sql. You may need a path. It
> may need / instead of \ for path parts.
>
> phpmyadmin can also do the "LOAD" of the .sql
> file.

I found this second option more problematic. Does the LOAD filename need quotes, i.e. 'filename'?

Options: ReplyQuote


Subject
Written By
Posted
Re: Install and Import a data base
June 11, 2014 05:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.