mysql0.blogspot.com
My SQL: September 2009
http://mysql0.blogspot.com/2009_09_01_archive.html
Monday, September 7, 2009. MySQL Command Line 2. To check mysql software version:. Root@192.168.33.121(none)]- select version();. 1 row in set (0.00 sec). Root@192.168.33.121mysql]- INSERT INTO user (Host,User,Password) VALUES('%','nbpm',PASSWORD('nbpm') ;. ERROR 1364 (HY000): Field 'ssl cipher' doesn't have a default value. Root@192.168.33.121mysql]- INSERT INTO user (Host,User,Password,ssl cipher,x509 issuer,x509 subject) VALUES ('%','nbpm',PASSWORD('nbpm'), 'NULL', 'NULL', 'NULL');.
mysql0.blogspot.com
My SQL: MySQL Backup Script
http://mysql0.blogspot.com/2009/03/mysql-database-backup-script.html
Sunday, March 29, 2009. This script is used on Windows 2003 (MySQL 5.0). It uses mysqldump. To create a *.sql backup then sends a notification e-mail.It works online.Its Pre-Requisites are BLAT and GZIP, for e-mail and compression. ECHO = = = = = = = = = = = = = = = = = = = = = = = =. ECHO MySQL Backup Script. ECHO Description: This scrip does the following:. ECHO - Backs up the specified database. ECHO - Compresses the backup. ECHO - Backup dump @ d :backups. ECHO - Writes to a log file. If not exist %b...
mysql0.blogspot.com
My SQL: Improve Hard Disk Speed
http://mysql0.blogspot.com/2009/03/to-improve-hard-disk-speed.html
Friday, March 27, 2009. Improve Hard Disk Speed. If hard disk of your computer or. Is taking too much time to get the result, then to improve your hard disk speed you will need to configure a special buffer in the computers memory in order to enable it to better deal with interrupts made from the disk. This tip is only recommended if your computer or. Has 256MB RAM or higher. Run SYSEDIT.EXE from the Run command. Expand the system.ini file window. Press Enter to make one blank line, and in that line type.
northoaks2.blogspot.com
FireBird: Is it dangerous to run sweep on live database with active users?
http://northoaks2.blogspot.com/2009/01/firebird-faq.html
Tuesday, January 27, 2009. Is it dangerous to run sweep on live database with active users? Subscribe to: Post Comments (Atom). How to repair a corrupt Firebird database? Firebird SuperServer running at 100% CPU? Why are sweep and mend exclusive operations? Is it dangerous to run sweep on live database with.
northoaks2.blogspot.com
FireBird: January 2009
http://northoaks2.blogspot.com/2009_01_01_archive.html
Wednesday, January 28, 2009. How to repair a corrupt Firebird database? Disconnect users and disable incoming connections to the database. Make a copy of database file (or two copies) and work on that. Use GFIX with -v option to validate the database file. Use GFIX with -v and -f to do full validation. If problem is not too serious, you can try to backup the broken db and restore under a new name:. Use GFIX -mend to prepare corrupt database for backup. Use GBAK -c to restore backup to a new database.
northoaks2.blogspot.com
FireBird: Why are sweep and mend exclusive operations?
http://northoaks2.blogspot.com/2009/01/why-are-sweep-and-mend-exclusive.html
Tuesday, January 27, 2009. Why are sweep and mend exclusive operations? Subscribe to: Post Comments (Atom). How to repair a corrupt Firebird database? Firebird SuperServer running at 100% CPU? Why are sweep and mend exclusive operations? Is it dangerous to run sweep on live database with.
mysql0.blogspot.com
My SQL: Date
http://mysql0.blogspot.com/2009/03/mysql-command.html
Monday, March 30, 2009. Mysql SELECT YEAR('2003-03-31');. Mysql SELECT YEAR('2003-03-31') 5;. Mysql SELECT NOW();. Mysql SELECT CURRENT DATE();. Mysql SELECT MONTH(NOW() AS m, DAYOFMONTH(NOW() AS d, HOUR(NOW() AS h, MINUTE(NOW() AS m, SECOND(NOW() AS s;. 3 31 1 53 38. Mysql SELECT DAYNAME('2000-01-01');. Mysql SELECT DAYOFWEEK('2000-01-01');. Mysql SELECT DAYOFYEAR('2000-12-31');. Mysql select (TO DAYS('2009-03-30')-TO DAYS('2009-03-01') ;. Mysql SELECT (TO DAYS(CURRENT DATE() -TO DAYS('2009-03-01') ;.
mysql0.blogspot.com
My SQL: MySQL Command Line 2
http://mysql0.blogspot.com/2009/09/mysql-command-line-2.html
Monday, September 7, 2009. MySQL Command Line 2. To check mysql software version:. Root@192.168.33.121(none)]- select version();. 1 row in set (0.00 sec). Subscribe to: Post Comments (Atom). MySQL Command Line 2. View my complete profile.
mysql0.blogspot.com
My SQL: MySQL Command Line
http://mysql0.blogspot.com/2009/03/command-line.html
Monday, March 30, 2009. C: mysql -h [hostname] -u [username] -p [password]. Mysql show databases;. Mysql use [one database name];. Eg mysql use test;. To view Tables and Table Structure:. Mysql show tables;. Mysql desc [tablename]; = show columns from [tablename];. Mysql show index from test.zoo; (= show keys from test.zoo; ). AUTO INCREMENT is used to generate a unique identity. Mysql CREATE TABLE zoo (. MEDIUMINT NOT NULL AUTO INCREMENT. Name CHAR(30) NOT NULL,. Auto increment = 100. Mysql use mysql;.