JSP Survey Library           SourceForge.net Logo

MySQL Help

Starting MySQL:
Starting MySQL On Windows
Starting MySQL On Linux/Unix
Starting MySQL On Mac OS X
Accessing the MySQL Data
Backing Up a MySQL Database

You can download MySQL from http://www.mysql.com/. Make sure to download MySQL 4.1 or newer. Documentation is at http://dev.mysql.com/doc/mysql/. This page only has some of the typical problems and questions that people have when using MySQL with the JSP Survey Library.

Starting MySQL on Windows

To start MySQL on Microsoft Windows, go to the "Start" menu, "Program Files", "MySQL" and select "MySQL System Tray Monitor" (see below, "A").
If it's not listed, select "WinMySQLadmin" (see below, "B") -- if you run "WinMySQLadmin" you won't need to perform the following step -- in your system tray you should just see a which means it's running.

Then, look in your task tray for the new icon. Right-click on it, and from the pop-up menu select "Start Instance".

Voila! It's done. If you want MySQL to start automatically every time you reboot your computer (recommended for any server that runs all the time), click "Configure Instance" to get a preferences window.

Starting MySQL on Unix/Linux

To start MySQL under a unix-based OS (except Mac OS X), open up a terminal, and type "mysqld_safe". If the command is not found, you probably did not install MySQL in the standard way.

Starting MySQL on Mac OS X

On Mac OS X, MySQL installs by default into /usr/local/mysql.
Open up a new "Terminal", then type the following things in the terminal window:


cd /usr/local/mysql/bin/
sudo ./mysqld_safe
[Then, type your password. At this point, MySQL is running. You only need to do the following if you want to run MySQL in the background and re-use the window or close it.]
[Press Control-Z]
bg


Then, MySQL will be running in the background, and you can close the Terminal.

Accessing MySQL Data

See the documentation for Getting Data From The Database.

Backing Up a MySQL Database

Follow these steps:
1) Download and install MySQL on your local machine (if it's not already installed) from MySQL.com OR ssh/telnet into a machine that has MySQL installed.
2) Open a shell:
a) In Windows, go to Start -> Programs -> Accessories -> Command Prompt.
Next, change directories to get into the folder with the MySQL .exe files (type something like "cd C:\Program Files\mysql\bin", depending upon where you installed MySQL)
b) In unix, you should open a terminal.
3) In that window, type:
mysqldump -h YOUR_SERVER_NAME YOUR_DATABASE_NAME -u YOUR_DATABASE_USER_ID --password=YOUR_DATABASE_PASSWORD > fileNameToBackupTo.sql

 

 

 

 
  Home
Screenshots and Demos
Help
  Installing
Building A Survey Using JSP
Getting Data
Clustering Survey
Java Web Start
Developers
Download
Contributors