Restoring a MySQL DB 1

[Negrazo]

Hi everyone:
I've just made a backup from my database, and I got a file with extension "sql"
I am using Perl on Windows XP.
The question is:
How can I restore this file using Perl???
My file is "backup20070319.sql" and contains all the Table structures and the records(rows) from each table.
Any help is welcome.

 

[spookie]

Just curious, why do you want to use Perl for restoring the DB. You can use mysql utility (i.e.mysqldump).



--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[TonyGroves]

You can execute the commands by simply piping the file into the mysql client program:
[tt]
mysql -u root -p12345 dbname <filename.sql
[/tt]
In a Perl program, just enclose that command in backticks to execute it.