Re: Remote Access to SQL Server via Internet

2001-07-14 Thread Joe Taraba
At 05:19 PM 07/13/2001 , you wrote: >Hi, > >I would like to be able to create some tables in a database on an SQL server >at my web provider, then access those tables via a client application >running on my PC over the Internet (dial-up connection). My understanding is >that the client application

Re: INSERT problem

2001-07-13 Thread Joe Taraba
Glyndower; I just joined the PHP mailing list. It appears to be fairly active and knowledgable. Your question seems to be MORE PHP related than MySQL. I know, I hate joining half a dozen lists to get answers, and the MySQL list has been most helpful with database questions, but this sounds lik

Re: Replication

2001-07-12 Thread Joe Taraba
Jeremy; I've been following this thread, and what I am unclear about is why would I want to use replication? Forgive me, I am very new to MySQL, and my point of reference at this juncture of understanding is as a new administrator of a MySQL server used for webhosting customers. I found the

Re: Php/MySQL Parse Error

2001-07-10 Thread Joe Taraba
database, does it need to be enclosed between double apostrophes inside the double quotes? I imagine, I'd eventually figure that out after some more trial and error--but hey, if you don't mind??? Joe > >>On Tue, 10 Jul 2001 17:33:10 -0700, Joe Taraba > <[EMAIL PROTECTED

Php/MySQL Parse Error

2001-07-10 Thread Joe Taraba
Group; There is something missing in my understanding of the php mysql_connect statement because I am getting a parse error as follows: http://cxkop.com/Jobs/job_list.php Parse error: parse error in /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31 The database exists and i

Re: Replication, update log, mysqldump???

2001-07-05 Thread Joe Taraba
would think that the database user/owner should be responsible for keeping their own copy of a mysqldump file, and me, as the Web server admin/ISP should keep backups of everything in /var/lib/mysql using a nightly cron. What do other users and administrators do? Joe >- Original Message ---

RE: Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
s for your help, I'm not totally stupid, it's just that I seem to have a fog in front of my eyes. Joe >that's just me. > >hth. > >-ravi. > >-Original Message- >From: Joe Taraba [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, July 04, 2001 1:48 PM >To: [E

Re: Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
eferring to all the changes in appendix "F. MySQL change history" that would take some REAL time to sort through. >- Original Message - >From: "Joe Taraba" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, July 04, 2001 1:4

Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
Hi; I'm trying to learn MySQL, having some difficulties understanding backup strategies. mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) Where is the documentation (besides man pages) for mysql Ver 3.22.32 According to the the 3.23.29 online docs it appears that there are four ways

Re: Relations between tables?

2001-07-04 Thread Joe Taraba
Mohan; I'm also new to this database administration and development. There are some excellent tutorials at Devshed.com. Below is a link to the tutorial on Database Normalization, I think this will give you some answers to your query: http://www.devshed.com/Server_Side/MySQL/Normal/ Joe At 0

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Joe Taraba
Diretor Técnico-Comercial >Galluch Soluções Internet >Telefax: 11 6912 3255 >Celular: 11 3176 7740 >http://www.galluch.com.br/ >-Original Message- >From: Joe Taraba <[EMAIL PROTECTED]> >To: Tiago Luchini <[EMAIL PROTECTED]> >Cc: [EMAIL PROTECTED] <[

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Joe Taraba
Just curious, can you convert access database to MySQL and visa versa. Meaning from win98 access 2000 to Linux Mysql 3.22.32? At 04:56 AM 07/02/2001 , you wrote: >Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com. > >Atenciosamente, > >Tiago Luchini >Diretor Técnico-Comercial >Galluch

ERROR 1062 at line 46: Duplicate entry '4' for key 1

2001-06-29 Thread Joe Taraba
Hi; I'm trying to learn MySQL, having some difficulties: mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) for pc-linux-gnu (i686) Getting the following error: ERROR 1062 at line 46: Duplicate entry '4' for key 1 What I did was: mysqldump -u jimjones -p XxXJimmy > lovingdata-Db-test