MySQL server on the Z - Revision history

Phil284: revert to remove spam

Phil284 — Fri, 24 Nov 2006 18:17:10 GMT

revert to remove spam

←Older revision		Revision as of 18:17, 24 November 2006
Line 42:		Line 42:

	You should now be able to start your mysql server.		You should now be able to start your mysql server.
-
-
-
-	[http://www.magical-casino.com/casino_download.html Casino Downloading Action.]
-	[http://www.magical-casino.com/security.html Casinos security online.]
-	[http://www.gambling-online-theory.com/online-casino/bet-online-casino.html bet online casino]
-	[http://www.casino-games-wiki.com/index.php/casino_games_online casino games online]
-	[http://www.gambling-online-theory.com/casinos-portal/best-casinos-online.html best casinos online]
-	[http://www.fortune-slots.com/ slots online]
-	[http://www.casinos-go.com/online-casino-tips/free-online-casino-slot.html free online casino slot]
-	[http://www.casino-theory.com/bingo-online/gambling-online-bingo.html gambling online bingo]
-	[http://www.gambling-online-theory.com/fortune-roulette/on-line-roulette-game.html on line roulette game]
-	[http://www.casinos-new.com/poker.html Online casino - Poker in casino]

Nichole at 18:04, 19 November 2006

Nichole — Sun, 19 Nov 2006 18:04:29 GMT

←Older revision		Revision as of 18:04, 19 November 2006
Line 42:		Line 42:

	You should now be able to start your mysql server.		You should now be able to start your mysql server.
		+
		+
		+
		+	[http://www.magical-casino.com/casino_download.html Casino Downloading Action.]
		+	[http://www.magical-casino.com/security.html Casinos security online.]
		+	[http://www.gambling-online-theory.com/online-casino/bet-online-casino.html bet online casino]
		+	[http://www.casino-games-wiki.com/index.php/casino_games_online casino games online]
		+	[http://www.gambling-online-theory.com/casinos-portal/best-casinos-online.html best casinos online]
		+	[http://www.fortune-slots.com/ slots online]
		+	[http://www.casinos-go.com/online-casino-tips/free-online-casino-slot.html free online casino slot]
		+	[http://www.casino-theory.com/bingo-online/gambling-online-bingo.html gambling online bingo]
		+	[http://www.gambling-online-theory.com/fortune-roulette/on-line-roulette-game.html on line roulette game]
		+	[http://www.casinos-new.com/poker.html Online casino - Poker in casino]

Offroadgeek at 02:57, 28 November 2004

Offroadgeek — Sun, 28 Nov 2004 02:57:13 GMT

←Older revision		Revision as of 02:57, 28 November 2004
Line 1:		Line 1:
	Here are a few tips on using MySQL server on the Z.		Here are a few tips on using MySQL server on the Z.

-	Downloading -	+	===Downloading===

	mysql server for the Z http://www.caulfei.demon.co.uk/zaurus/		mysql server for the Z http://www.caulfei.demon.co.uk/zaurus/
		+	or from the [[http://www.zaurususergroup.com/feed/ ZUG Feed]]

-	Installing -	+	===Installing===

	Transfer the ipk onto your Z and switch to the Settings tab, then tap on the Add/Remove Software icon. %%% On the next screen you will want to tap on the Install packages button. You should see a package called mysql. %%% Tap the app to start the install. (You may install this package on a CF card, but I would suggest installing it on your Z's internal memory first)		Transfer the ipk onto your Z and switch to the Settings tab, then tap on the Add/Remove Software icon. %%% On the next screen you will want to tap on the Install packages button. You should see a package called mysql. %%% Tap the app to start the install. (You may install this package on a CF card, but I would suggest installing it on your Z's internal memory first)

-	Starting -	+	===Starting===

	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstart. %%% If successfull the screen will display 'Starting MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Welcome to the MySQL monitor. %%% Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.22.32-log. Type 'help' for help.'		From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstart. %%% If successfull the screen will display 'Starting MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Welcome to the MySQL monitor. %%% Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.22.32-log. Type 'help' for help.'

-	Stopping -	+	===Stopping===

	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstop. <br>If successfull the screen will display 'Stopping MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).'		From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstop. <br>If successfull the screen will display 'Stopping MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).'

-	Creating tables -	+	===Creating tables===

	I would suggest downloading on of the many GUI apps for working with MySQL. They are available at www.mysql.com. If you are a beginnner this is the way to go.		I would suggest downloading on of the many GUI apps for working with MySQL. They are available at www.mysql.com. If you are a beginnner this is the way to go.

Offroadgeek at 02:55, 28 November 2004

Offroadgeek — Sun, 28 Nov 2004 02:55:43 GMT

←Older revision		Revision as of 02:55, 28 November 2004
Line 1:		Line 1:
	Here are a few tips on using MySQL server on the Z.		Here are a few tips on using MySQL server on the Z.

-	Downloading -	+	Downloading -

-	mysql server for the Z http://www.caulfei.demon.co.uk/zaurus/	+	mysql server for the Z http://www.caulfei.demon.co.uk/zaurus/

-	Installing -	+	Installing -

-	Transfer the ipk onto your Z and switch to the Settings tab, then tap on the Add/Remove Software icon. %%% On the next screen you will want to tap on the Install packages button. You should see a package called mysql. %%% Tap the app to start the install. (You may install this package on a CF card, but I would suggest installing it on your Z's internal memory first)	+	Transfer the ipk onto your Z and switch to the Settings tab, then tap on the Add/Remove Software icon. %%% On the next screen you will want to tap on the Install packages button. You should see a package called mysql. %%% Tap the app to start the install. (You may install this package on a CF card, but I would suggest installing it on your Z's internal memory first)

-	Starting -	+	Starting -

-	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstart. %%% If successfull the screen will display 'Starting MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Welcome to the MySQL monitor. %%% Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.22.32-log. Type 'help' for help.'	+	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstart. %%% If successfull the screen will display 'Starting MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Welcome to the MySQL monitor. %%% Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.22.32-log. Type 'help' for help.'

-	Stopping -	+	Stopping -

-	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstop. ~~%%%~~ If successfull the screen will display 'Stopping MySQL database server: mysqld.' To test that you MySQL server is ~~%%%~~ stopped you can type MySQL. You will recieve a 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).'	+	From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstop. <br>If successfull the screen will display 'Stopping MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).'

-	Creating tables -	+	Creating tables -

-	I would suggest downloading on of the many GUI apps for working with MySQL. They are available at www.mysql.com. If you are a beginnner this is the way to go.	+	I would suggest downloading on of the many GUI apps for working with MySQL. They are available at www.mysql.com. If you are a beginnner this is the way to go.

-	Changing the location of your data files -	+	Changing the location of your data files -

-	To change the location of you database files for MySQL you will need to do the following.	+	To change the location of you database files for MySQL you will need to do the following.

-	Edit the /etc/mysql/my.cnf file.	+	Edit the /etc/mysql/my.cnf file.

-	Change the following line.	+	Change the following line.
-	datadir = /var/lib/mysql	+	datadir = /var/lib/mysql
-	to	+	to
-	datadir = /mnt/cf/mysql	+	datadir = /mnt/cf/mysql
-	Save your changes over the existing /etc/mysql/my.cnf file.	+	Save your changes over the existing /etc/mysql/my.cnf file.
-	Make sure when it saves that it saves as my.cnf, not	+	Make sure when it saves that it saves as my.cnf, not
-	mn.cnf.txt like the crummy Text editor on the Z likes	+	mn.cnf.txt like the crummy Text editor on the Z likes
-	to do.	+	to do.

-	Next, make a directory on you cf card to store the data. I created a /mnt/cf/mysql directory. This is the directory that you pointed your datadir to in the my.conf file you edited.	+	Next, make a directory on you cf card to store the data. I created a /mnt/cf/mysql directory. This is the directory that you pointed your datadir to in the my.conf file you edited.

-	After creating the /mnt/cf/mysql directory you will need to go to your old datadir (/var/lib/mysql) and copy the entire contents of this folder into your new /mnt/cf/mysql folder.	+	After creating the /mnt/cf/mysql directory you will need to go to your old datadir (/var/lib/mysql) and copy the entire contents of this folder into your new /mnt/cf/mysql folder.

-	You should now be able to start your mysql server.	+	You should now be able to start your mysql server.

Offroadgeek at 02:54, 28 November 2004

Offroadgeek — Sun, 28 Nov 2004 02:54:05 GMT

New page

Here are a few tips on using MySQL server on the Z.

Downloading -

mysql server for the Z http://www.caulfei.demon.co.uk/zaurus/

Installing -

Transfer the ipk onto your Z and switch to the Settings tab, then tap on the Add/Remove Software icon. %%% On the next screen you will want to tap on the Install packages button. You should see a package called mysql. %%% Tap the app to start the install. (You may install this package on a CF card, but I would suggest installing it on your Z's internal memory first)

Starting -

From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstart. %%% If successfull the screen will display 'Starting MySQL database server: mysqld.' To test that you MySQL server is stopped you can type MySQL. You will recieve a 'Welcome to the MySQL monitor. %%% Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.22.32-log. Type 'help' for help.'

Stopping -

From the Application tab you will want to tap the Terminal icon to open a terminal session. From the terminal line you will type mysqlstop. %%% If successfull the screen will display 'Stopping MySQL database server: mysqld.' To test that you MySQL server is %%% stopped you can type MySQL. You will recieve a 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).'

Creating tables -

I would suggest downloading on of the many GUI apps for working with MySQL. They are available at www.mysql.com. If you are a beginnner this is the way to go.

Changing the location of your data files -

To change the location of you database files for MySQL you will need to do the following.

Edit the /etc/mysql/my.cnf file.

Change the following line.
datadir = /var/lib/mysql
to
datadir = /mnt/cf/mysql
Save your changes over the existing /etc/mysql/my.cnf file.
Make sure when it saves that it saves as my.cnf, not
mn.cnf.txt like the crummy Text editor on the Z likes
to do.

Next, make a directory on you cf card to store the data. I created a /mnt/cf/mysql directory. This is the directory that you pointed your datadir to in the my.conf file you edited.

After creating the /mnt/cf/mysql directory you will need to go to your old datadir (/var/lib/mysql) and copy the entire contents of this folder into your new /mnt/cf/mysql folder.

You should now be able to start your mysql server.