mysql dump files

[Anon]

Hey,

To date, I've been working on sites with telnet access and created tables and populated them with dump files created using mysqldump. However, if there is no telnet access, what options do I have. Is there a way through php, besides passthru() or exec() to use a dump file to build the db tables? Is there a way through a phpmysqladmin front end to use a dump file?

Thanx,
Bel Dan

[truehand]

In phpMyAdmin, create the database you want to dump to. Click on the database. Under the option "Run SQL query/queries on database <database>", select the browse Location. Find the dump file on your system. Click "Go".

[neuromancer]

Sure, why don't you make a script that splits on ; and executes every command in the dump file with mysql_query ?