Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)? ...
according to http://stackoverflow.com/questions/577463/finding-how-similar-two-strings-are there are several methods to calculate the similarity measure between two strings. Soundex is a very poor algorithm and it's currently available for mysql. Is there any other method implementation available for mysql? ...
Can not find a command that displays the current configuration of mysql from within the database. I know I could look at /etc/mysql/my.cnf but that is not what I need. ...
I have a development database (MYSQL) which I would like to load with fresh data at some point. I would like to delete the content of all tables. What is the best way, as automated as possible, to delete the content of all tables (including those that have foreign key constraints). Is there a truncate all/ drop all equivalent constraint...
I am going to be making a small user system but I have questions. If I were to make a registration table (mysql), what is wrong with just storing the password and username into the database without encryption? I am trying to think of how to build the admin portion. Should I just check a column in the database to see if user is admin or...
Yesterday I was working on a shell script to perform some moderately complex table insertions to a MySQL database. Naturally I was keeping a mysql client shell window open to for running describe commands, sample queries, and to remove my test rows between test cycles. Yes this was on a live, production database. At the point where I ...
My fellow developers and I have our own development schemas on a shared MySQL development database. My assignment requires me to create triggers in my schema, yet I've been unsuccessful so far. CREATE TRIGGER myTrigger AFTER DELETE on myTable FOR EACH ROW BEGIN -- DO STUFF END; MySQL says: ERROR 1419 (HY000): You do not have the ...
Did you try amazon-rds? How is it, performance-wise? ...
My py-mysql is farking because I've upgraded MySQL which replaced libmysqlclient_r.15.dylib with libmysqlclient_r.16.dylib. How do I find and get back the older version? EDIT: I found that to intall an older version of MySQL, I need to do @, but I'm still looking for the way to find the older versions. ...
I've a database with 3 of the tables having rows in excess of 20 million each. I've used GUIDs as primary keys (unfortunately). Now our database is about 20GB and growing 5GB per month. It takes about 2 hrs to take full backup of the database, and 30hrs to restore on a box with 4GB RAM. We once have all the tables from database disappe...
What is the best GUI for managing MySQL 5.1 installation? Would like something as close to SQL Server's management tools as possible as that's where my experience is. The management client would need to run under Windows (XP, Vista (32 and 64-bit flavors), and 7 (32 and 64-bit flavors). ...
Hi guys, I'm trying to upload a 95Gb csv file into a MySQL database (MySQL 5.1.36) via the following command: CREATE TABLE MOD13Q1 ( rid INT UNSIGNED NOT NULL AUTO_INCREMENT, gid MEDIUMINT(6) UNSIGNED NOT NULL , yr SMALLINT(4) UNSIGNED NOT NULL , dyyr SMALLINT(4) UNSIGNED NOT NULL , ndvi DECIMAL(7,4) NOT NULL comment 'NA value is 9', r...
Hi. I am about to start building a new site in Wordpress on the same domain as the old site. I need the old site to stay live until the new one is launched and I also need to develop online. What is the best way to go about this? Should I create a subdomain or subfolder? How would I go about migrating the Wordpress site & database fro...
Hi, I would like to have a tool with which I can easily develop(dragNdrop) front-end for mysql table and publish it to web. I am not sure whether I can try oracle forms, as my database is MySQL. Even if I can use Oracle forms to connect to MySQL, I would like to know any other third party tool which can do the job easily & quickly. Th...
Is there a way in mysql to write a re-runnable sql script? I tried the : 'IF EXISTS' syntax but that only seems to work for stored procedures. It doesn't seem the 'select if' syntax will do what I want. Ideally I would like to do something like: IF NOT EXISTS (select * from table where name='Name') Then insert into table values('Name')...
I have: 32 bit - Red Hat Enterprise Linux Server release 5.1 (Tikanga) Mysql 5 10G RAM What are the memory allocation limits with respect to mysql? Maximum memory usage possible. Any supporting documents from redhat site? ...
I'm building a web app. This app will use MySQL to store all the information associated with each user. However, it will also use MySQL to store sys admin type stuff like error logs, event logs, various temporary tokens, etc. This second set of information will probably be larger than the first set, and it's not as important. If I lo...
is there a way to automate to install MySQL without having to use the wizard to specify root password, etc. Basically, I need to install MySQL as simple as possible for the end user. Thanks ...
How to delete INDEX from a mysql MyISAM table using the command "myisamchk"? The ALTER TABLE products DROP INDEX productname command gives a Error message "Lost connection to MySQL server during query" continuously. The table contains around 4million records Thanks ...
How can I change the root password of MySql to null --> ("") from the MySql CommandLine Client ? ...