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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
