Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Create and upload mySQL DumpFile
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

energy
Starting Member

29 Posts

Posted - 22 May 2002 :  14:29:52  Show Profile
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 [;-)]

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 22 May 2002 :  19:17:25  Show Profile
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 !
Go to Top of Page

energy
Starting Member

29 Posts

Posted - 22 May 2002 :  21:03:28  Show Profile
its a private webspace and so there is no webinterface or something else :(

Is there no possiblity to bring the dump file with mySQL-Front in?

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 23 May 2002 :  00:44:01  Show Profile
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 !
Go to Top of Page

energy
Starting Member

29 Posts

Posted - 23 May 2002 :  10:50:02  Show Profile
yes, it works perfectly!
i love mySQL-Front :)

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 23 May 2002 :  11:35:19  Show Profile
Glad it worked for you.

«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists !
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07