On Thu, 2002-09-26 at 18:28, Mihail Manolov wrote:
> mysql < datadump.sql
Thanks, I finally found it. the mysql manual doesn't have anything about
exporting/importing, I was using the wrong words for searching.
--
Chip
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PR
mysql < datadump.sql
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 4:44 PM
Subject: db dump question
> I need to copy a database and all its tables and contents to a backup
> server. The server
> they live on is on an ISP, the
Since you have already dumped the structure and data to a file all you need to
do is paste the contents of that file to mysql. You could also use phpMyAdmin
(since you mentioned using it) to load the entire text file - look under
the 'SQL' tab (in more recent versions).
Quoting [EMAIL PROTECT