Now i'va a huge mySQL database ( 10 MB ) and i made a dump file with mySQL-Front >> database.sql (i think this is a dumpfile??)
Now my question. How can i upload or to bring in the mysql dump file on a nother server or may on the server where the file is from (after a headcrash or so...)
thnx for help energy wiht the worst english i ever heard [;-)]
If your other server has some control panel that allows you to manage your mysql server, it should have an option where you can use a dump file to create the tables.
«------------------------------------------------------» Want to know when the next version comes out, as soon as possible? Join our Mailing Lists !
I believe you can, although i have never tried it. Just enter in the server address or ip of your mysql server and your mysql username and password and also the name of your database then click the connect button.
When you have successfully connected, click on the database on the left. On the right hand side, you should see a tab called "SQL Query", click on that. At the top right hand you should see a new toolbar. Click on the open folder icon. Select the sql dump file you created and click Open. It should load the sql file in the text screen. Just click the green arrow in the same toolbar at the top and it should execute the dump file.
Good luck.
«------------------------------------------------------» Want to know when the next version comes out, as soon as possible? Join our Mailing Lists !
Topic Locked
Posted - 22 May 2002 : 14:29:52
) and i made a dump file with mySQL-Front >> database.sql (i think this is a dumpfile??)
