Re: Transfering database
| From: | Jeroen Serpieters | Date: | Thu, 27 May 2004 06:49:11 +0000 |
| Subject: | Re: Transfering database | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23854@lists.php.net to get a copy of this message | ||
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