Backup / Import Questions

2001-07-30 Thread KPortsmout
Hi, I have built a database with 7 tables in it, the time has come when I need to create a suitable backup system so off I went to my manuals. I read through the mysqldump command and everything seemed straight forward. I ran the following... mysqldump -uroot -ppassword --opt Database > fil

Re: Enquiry

2001-04-06 Thread KPortsmout
In a message dated 07/04/2001 05:13:18 GMT Daylight Time, [EMAIL PROTECTED] writes: << This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest v

Re: Delete Again?

2001-03-29 Thread KPortsmout
In a message dated 30/03/2001 04:42:44 GMT Daylight Time, [EMAIL PROTECTED] writes: << What doesn't work and where is your delete statement? >> This is my full code $www_domain="select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Fa

Delete Again?

2001-03-29 Thread KPortsmout
Hmmm Well I didn`t manage to get any of those examples to work. This is my select statement.. "select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where www_domain_

Delete?

2001-03-29 Thread KPortsmout
Hi, I`m just trying to figure out the best method to delete my records and wondered if it was possible to do a DELETE statement to remove any records that don`t match. Here is my code so far $Query="select blah its huge:-)"; $RESULT=mysql_query($Query); $my_rows=mysql_num_rows($RESULT); for

Match Um up

2001-03-29 Thread KPortsmout
Hi, I have two database`s with one table in each. (MySQL) Is there a way that I can select data from one table and then match it with the data in another and discard the results so all I am left with is the original data from the first table which never matched up. Database1 EmailAddress

Re: http://lists.mysql.com/php/unsubscribe.php

2001-03-26 Thread KPortsmout
In a message dated 26/03/2001 12:14:36 GMT Daylight Time, [EMAIL PROTECTED] writes: << I can't unsubscribe either - I do not receive an auth code from this page http://lists.mysql.com/php/unsubscribe.php after I've entered my email address, so I cannot unsubscribe myself. If someone can

MySQL Backup

2001-03-23 Thread KPortsmout
Hi, I`m having trouble backing up MySQL on my Cobalt RAQ4r server, I have tried all the methods I can find in the manual but all it ever seems to do is print out some instructions which leads me to beleive I`m doing something wrong, can anyone help? I basically want to backup all of my databa