I have a project using a MySQL database that needs to run on a different server using the data I already have?

Question

I am programming using a mySQL database running on my local machine, yet, it is a school project that needs to run on the school secure servers.... we have access to the MySQL commands in these machines, but no access to external machines, so I need a way to migrate all the data in my database to this other machine.... I am using a JSP/Java project using a Tomcat Apache server, in case that helps...I am currently writing a huge transaction to create the database, the tables and write all the data, but there ahs to be an easier way.... i have a lot of tables and a lot of data... please help!

Answer 1

Hullo, there a couple of Free GUI Mysql database tools that can help you export your database to an SQL script that you will later run on your school server to recreate the database,

Try any of these softwares;



MySQL Administrator

Mysql Front

Answer 2

You can do a data dump from MySql which basically generates a table creation script along with a bank of SQL scripts which will populate the table. Just take the dump along on a disk and execute the SQL in a front end manager.

You can google the exact syntax for the data dump which is done in a DOS shell. Very easy and useful to back up data.

Answer 3

before everything... i imagine it is a marginally vast undertaking, and that i wish you're not from now on wanting all and distinct to do your homework for you.... now, if it replaced into me and without the college room hours that you've i'd say.... you want a T1 or T5 organization type internet service at both places. you want a server type server with a server type OS on the server region, 2 routers and a bridge for a VPN, to connect both clusters. percentage permissions on each between the workstations to percentage archives, a printer server on each between the loations so as that they can print, webcam to seize streaming video and encoding to broadcast, possibly even VoIP. of direction, static IP on the server region to ascertain RAS, yet is larger to do a hardware setup, because software VPN's are great slow and not sturdy for AV. about the first of the routers, VPN's, and bridges, they could might want to be managed routers, sysco if plausible (very intense priced). the call manufacturers and specifications for each piece of kit... the same old suspects... Dell optiplex, Compaq, and so on... the samething for the server. residing house windows stepped ahead Server or Unix. and Sysco routers, and a sturdy team of sysco qualified community ingeneers... the thanks to set all of that up? i guess it is your homework... it is in case you favor to connect over the web... yet you are able to pass with fiber optics for the length of both campuses and it might want to be a speedier community.

Answer 4

connect to the source, use mysqldump to pump out the data, then import on the destination machine

Answer 5

What about using



http://www.phpmyadmin.net/home_page/index.php



? easy enuf to create and manage sql databases. i think it has an export & import function aswel so you can tranfer.