MySQL for the Enterprise
Hello Everyone I have been using MySQL on Linux for over two years and am a devoted fan. I have been using MySQL for very ordinary applications till now. Now there may be a requirement that we need to build an enterprise application running on MySQL. The application must be very reliable, very fast, and scalable. The other vendor in competition is Oracle. Can someone on the list point me to resources or case studies where enterprise level MySQL has been used and the system implemented successfully. Thanks Asaf Maruf PING Karachi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto Increment
Dear All I am inputting data into a MySQL database where i have set the primary key as the ID and it is auto-incrementing. I make sure that my input file contains a null or 0 value where it should be auto- incrementing. While entering data using LOAD command, my input file had an error with the result that erroneous values were entered. I deleted them no problem. However, this disturbed the sequence of the db. Suppose, my records were at 100 and i entered data of 50 lines then my ID starts from 150 instead of 101. How can i reverse the count so that my ID starts from 101 with the good data. Thanks in advance Asaf Maruf [EMAIL PROTECTED]
MySQL data structure
Hello. I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by O'Reilly states that for a table named book under a database Test following is the structure: book.ISM book.ISD and book. frm On my system MySQL 3.23.27 beta the structure is different. book.MYI book.MYD book.frm Any suggestions would be welcome. Suggestions on backing up the MySQL db as well. Anyone has experience of hosting MySQL/PHP ? Any recommended server/host/company? Thanks in advance
Locked Out
I have been using MySQL for sometime now. However, i had been experimenting with MySQL priviliges and have locked myself out. I cannot access the database to perform any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow the command mysqlaccess doesnt execute either. The message i get trying to access mysql is: Access denied to user root@localhost using (password=NO) If i try to connect to the DB using mysql -p and give any password the message is: Access denied to user root@localhost using (password=YES) Unfortunately, i didnt note down the changes i made to the host, DB and user tables. Any help would be really appreciated. Thanks Asaf Maruf PING
