xgab

I have found a freeware version of SQLyog ! The current published on-line version 3.2 is paid... but version 3.1 is still freeware! Thank you all!

I already considered sqlyog, but... unfortunately is not freeware...

Hi! This is my first experience importing comma, pipe or tabs delimited plain files into a MySQL Database. I tried using more than one tool and none of them worked... The thing is that one of the plain files has 250,000 records. - I tried with a nice freeware script called CSV Importer. It enabled me to import succesfully one plain file of 6,000 records, but the second one has 24,000 and it uploaded only 8,000 (so the largest one will be imposible). Does anyone ever used CSV Importer ? (downloaded from hotscripts.com) - Then I tried with the latest PHPMyAdmin system. It is very clear how to export information, but I could not figured out how to import!. There is an import link at the little SQL window that asks me for a txt file, but it is not clear how to format and process it. - I also tried with a Windows freeware to create the .sql file from Access. It created a huge file with many INSERTs. How should I process that big file, thru the little PHPmyAdmin SQL window ??? - Finally I tried with LOAD FROM and mysqlimport, but... unfortunately I get many errors and warnings and the help information at the mysql site is not enough for me... I a newbie :-( Which is the best option or technique to import large amounts of records ? The server I use is Linux Mandrake with PHP 4.3.3, the latest MySQL and also my PC is Windows XP. I will apreciate you help. Than you!

Hi, I developed a Poll system that uses cookies. It works fine under Windows (Apache and MySQL), but it does not work properly under Linux. Cookies does not work when I use the system under Linux (Apache and MySQL). I already checked Webmin, php.ini but it does not read the cookie so the same visitor can vote more than one time. Could you help me ? Thank you! Gabriel