Re: mysql import database question
On Wed, Nov 17, 2004 at 11:08:23AM -0800, Curtis Vaughan wrote:
> I am totally new to mysql so please forgive me if this question has a
> very simple solution.
>
> Someone sent me a mysql database file dumped from phpmyadmin. I have
> installed and configured phpmyadmin to connect to the mysql server.
> Using phpmyadmin I created a database, but how do I now import that
> dumped file into that database?
I don't have experience with importing or exporting a dump from
phpmyadmin. I use the command line for dumping and importing a dump:
mysql databasename < dumpfile
In phpMyAdmin you can select the database, possibly clear it if there
is data in there and go to the SQL tab and for the SQL Query load the
dumpfile. That ought to work, as the dump files I work with are simply
a lot of SQL queries after each other.
I just tested it and that seems to work just fine.
[Hey, I just saw that phpMyAdmin can now also export a database in
LaTeX format. Nice!]
--
Maurits van Rees | http://maurits.vanrees.org/ [Dutch/Nederlands]
"Let your advance worrying become advance thinking and planning."
- Winston Churchill
Reply to: