port fwding connection

Hi, I have a MySQL server running on a machine, say A, and I want to access the DB from another machine B. Now A has blocked port 3306. So I fwded port 3306 on B to 3306 on A using SSH. This works just fine. I can access Mysql fom local machine's port 3306 and no problems there. Problem is it w

Re: where is my data?

, Kaustubh Original Message Follows From: Michael Stassen <[EMAIL PROTECTED]> To: "kaustubh shinde" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: where is my data? Date: Mon, 04 Apr 2005 12:45:04 -0400 On Apr 2, 2005, at 7:58 AM, kaustubh shinde wrote: Hi, I h

Re: where is my data?

Thank you very much. that was a real life saver. u rock :) Regards Kaustubh Original Message Follows From: Thomas Spahni <[EMAIL PROTECTED]> To: kaustubh shinde <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: where is my data? Date: Mon, 4 Apr 2005 12:03:05 +02

where is my data?

Hi, I have suse 9.2 and MySQL 4.21 My basedir is /var/lib/mysql datadir /data/mysql/mysqldata Both the directories and subdirectories and files are owned by user mysq,l group mysql with rights 755. So I guess I have got the permissions part right or so I hope. Everything was working fine till I d

Re: permission denied error

g in the mysqld.log file in the /data/mysql dir. Original Message Follows From: Michael Stassen <[EMAIL PROTECTED]> To: kaustubh shinde <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: permission denied error Date: Sun, 06 Mar 2005 13:16:45 -0500 Usually, datad

permission denied error

Hi, I have moved my base and data directories at /data/mysql on my system and /data/mysql is owned by user mysql. Earlier these were located at /var/lib/mysql my /etc/my.cnf has following entries: # The following options will be passed to all MySQL clients [client] #password = your_passwor

symlink to /var/lib/mysql

Hi all I recently installed SUSE linux and I am running MySQL 4.0.21 The way system is configured, /var ran out of disk space. I have RAID installed and /data is on raid. So I created a new folder mysql in /data and copied all the files from /var/lib/mysql to this folder. I renamed /var/lib/mysql

Re: Error 1054

Hi, Following is the output of show create table Spot command | Table | Create Table

RE: Error 1054

backticks didnt work :( --- Victor Pendleton <[EMAIL PROTECTED]> wrote: > Try using backticks `ID` > > -Original Message- > From: kaustubh shinde > To: [EMAIL PROTECTED] > Sent: 5/26/04 1:05 PM > Subject: Error 1054 > > Hi, > I have a table Spot in the

Error 1054

Hi, I have a table Spot in the database as follows desc Spot -> ; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | Name | varchar(32) | YES |