Unix administration - Creating mysql database

This is Interesting: Free IT Magazines  
Home > Archive > Unix administration > November 2004 > Creating mysql database





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Creating mysql database
Konrad

2004-11-02, 7:48 am

Maybe it's not a proper place to ask this question, but maybe someone
could provide me the way to load file with schema and data of mysql
database (created by phpMyAdmin on Windows system), to create a new
database on linux system.


Greetings,

Konrad
Kevin Collins

2004-11-03, 5:53 pm

In article <518b4831.0411020510.754e0e75@posting.google.com>, Konrad wrote:
> Maybe it's not a proper place to ask this question, but maybe someone
> could provide me the way to load file with schema and data of mysql
> database (created by phpMyAdmin on Windows system), to create a new
> database on linux system.
>
>
> Greetings,
>
> Konrad


Not really the place to ask, but this should work:

# mysqladmin create your_db
# mysql your_db < your_dump_file

You will probably want to also specify -p (and maybe '-u your_user') to both
commands.

Kevin
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com