Re: LOAD DATA INFILE (url)

currently have something like this running... i make a dump file on the remote server runing a script with crontab. i gzip that file just to make the file transfer faster . the local server then fetches the file (wget) and gunzips it and then i load the file. works pretty good. -- Arno Co

Re: Help with an SQL query

? Thanks. select VBS_ID , max(Date) from weight -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobile : +27 82 693 6180 Fax : + 27 12 430 4269 www.flashmedia.co.za <http://www.flashmedia.co.za/tms.php >> -- MySQL General Mailing List For list archives: http://lists.

Re: Counting total results from a table

27;) i don't know what the ID field in the select clause is for , so i omitted it. i suspect the ID field in the select clause caused the prob. shout if you need more help. -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobile : +27 82 693 6180 Fax : + 27 12

Re: Restore using mysqldump (MySQL 4.1.12)

option. Can someone please help? Thanks you all. Wayne. J. Wayne Doneker BAE Systems York Pa. 717 225 8109 Email: [EMAIL PROTECTED] try this wayne mysql 'databasename' <'filename' -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobil

Re: alter table

s. keeling wrote: Incoming from Arno Coetzee: s. keeling wrote: Grr. Please, what's wrong with this?!? alter table MEMBERS alter MEMBER_INFO varchar(160); ERROR 1064: You have an error in your SQL syntax. Check the manual \ that corresponds to your MySQL server version fo

Re: alter table

rver version for the right \ syntax to use near 'varchar(160)' at line 2 The field exists, but I'd like it to accept more chars. Debian/Gnu Linux Testing/Etch, MySQL 4.0 http://dev.mysql.com/doc/mysql/en/alter-table.html -- Arno Coetzee Developer Flash Media Group Office :

Re: Find username password on tables

root user. Thanks, Scott use the mysql database and look in the user table .. you will be able to see all the users there , as well as the privileges. you will have to reset the password for the user you want to use... use the 'grant' statement to reset the password. hope

Re: mysql no series

To: Sent: 04/10/2005 2:19 PM Subject: Re: [Fwd: MySQL in C - I need help!] is this fields datatype varchar? does it have to be a text field? change the datatype to int , double etc. depending on your needs -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693

Re: I forgot the admin password

good luck Luis -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 7595 Mobile : +27 82 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error in Update Command Text - What am I missing

-- --- UPDATE Clients_Master SET Label='', Title='Mrs', FName='Jane', MName='', SName='Doe', Building='', Unit='', STNumber='', STName='', STType='', STSuburb='', STSta

Re: backup and restore a database in a query ？

shuming wang wrote: Hi, Could we do a database dump/backup in a query like below ? mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u root -p -C mydb>mydbfile or restore a database in a query like below ? mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup a

Re: Data sync offline

the daily process. -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Order By Question

n. /Johan or maybe a datetime field and order by the datetime. i was never a big fan of auto-increment. ;-) -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Query Help

as sj where s.studentID = sj.studentID and sj.Grade = 'A' and (sj.Subject = 'Maths' or sj.Subject = 'Chem') I think your query will return student 3 as well My apologies. Misunderstood the question... -- Arno Coetzee Developer Flash Media Group Office : 2

Re: Query Help

entID = sj.studentID and sj.Grade = 'A' and (sj.Subject = 'Maths' or sj.Subject = 'Chem') -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Best practices for deleting and restoring records - moving vs flagging

hi bastian just a thought. rather stay away from auto_increment PK's and rather generate your own PK. i have run into trouble a couple of times using auto_increment when i made backups and restored the data again. The PK changed and i had records in other tables referencing the old PK

Re: Best practices for deleting and restoring records - moving vs flagging

is that you might sacrifice some speed(depends on the number of records in the table.) If the table does not grow that fast most def just flag the records as deleted. my2c worth -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing