Re: Transfering database
| From: | Sudeep Zamudra | Date: | Thu, 27 May 2004 07:13:40 +0000 |
| Subject: | Re: Transfering database | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23859@lists.php.net to get a copy of this message | ||
Thanx for your suggestions. But i am looking for a php script by which i can do this not from the
mysql shell command line. If any has it . Please suggest it to me.
Thanx
Jeroen Serpieters <jeroen@lunitechs.com> wrote:
On Wed, 26 May 2004, Sudeep Zamudra wrote:
>
> I have dumped my entire database into files with extension '.sql' (separate file for
> each table). Now please tell me any function or statements if any to tranfer the contents of the
> file(i.e table structure and table contents) into a new database which is on another database
> server. I guess there is a statement for this. Help please.
>
mysql -u username -p database < C:\path\to\your\dump\file.sql
--
Jeroen
There are only two kinds of programming languages: those people always bitch about and those nobody
uses.
-- Bjarne Stroustrup
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger