MySQL |
| Tuesday, 04 September 2007 15:55 | |||
|
MySQL :: Download Connector/Net - go here to get the latest connector for .net mysql access. MySQL :: MySQL 5.0 Reference Manual :: 2.18.5 Copying MySQL Databases to Another Machine Real Programmers: How To: Set Up An Ssh Tunnel With Putty (mysql) SSIS Stuff : Connecting to MySQL from SSIS maatkit - Project Hosting on Google Code - Maatkit (formerly MySQL Toolkit) contains essential command-line tools for MySQL, such as table checksums, a query profiler, and a visual EXPLAIN tool. It provides missing features such as checking whether slaves have the same data as the master. MySQL :: Download Connector/ODBC Download details: SSMA 2008 for MySQL v1.0 CTP1 HeidiSQL - MySQL made easy - a nice gui for mysql. innotop - The best top clone for MySQL, with special attention paid to InnoDB - Google Project Hosting Writing MySQL Scripts with Python DB-API Doing INTERSECT and MINUS in MySQL | Carsten’s Random Ramblings What version of mysql am I running again?select version() Find duplicate rowsSELECT name FROM atable GROUP BY name HAVING COUNT(*) > 1; Grant all priv to root mysql user.GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost.localdomain' WITH GRANT OPTION; Getting mysql to work on ubuntu with mysql_configapt-get install gcc libc6-dev python-dev libmysqlclient15-devgot a packet bigger than 'max_allowed_packet'Edit your /etc/my.conf and inside [mysqld] set max_allowed_packet=100M. Restart mysqld. Then to additionally be sure, set the cmd line params on the client ie. 'mysql --max_allowed_packet=100M' Might not want to leave it so high, but it does get past this error.remember to change that passwordPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h a.host.com password 'new-password' Reset your mysql passwordmysqld_safe --skip-grant-tables &Recover MySQL root password [hack] | Ranjith Siji | Programming the Web Comparing and diffing mysqlAn algorithm to find and resolve data differences between MySQL tables at Xaprbmysql_coldiff mysqldiff -- a utility for comparing MySQL database structures Synchronizing Your MySQL Databases Using a Free MySQL Admin Tool - SQLyog — DatabaseJournal.com Replace data within your tableSometimes you'd like to replace certain text within your tables...for example here's a query I used to replace all my bad br's...UPDATE `jos_content` SET introtext = replace(introtext,"<br>","<br/>") WHERE introtext like '%<br>%'; MySQL performanceOptimizing MySQL performance « Sachin’s WeblogSample datasets for benchmarking and testing - MySQL Performance Blog MySQL replicationLive Backups of MySQL Using Replication - O'Reilly Media"Unable to convert MySQL date/time value to System.DateTime"When connecting to MySQL from .net connector, you may find you get an error like: "Unable to convert MySQL date/time value to System.DateTime". To handle this, you can fix the offending dates or use a connection string that converts zero (invalid) DateTime to the minimum DateTime value (DateTime.MinValue). To do this, add ";Convert Zero Datetime=True" to the end of your connection string.How to fix “Unable to convert MySQL date/time value to System.DateTime” exception when using MySQL .NET Connector « George Birbilis @zoomicon
|
|||
| Last Updated on Sunday, 15 January 2012 16:26 |