mysql-management

mysql software: any suggestions to oversee my mysql replication server?

I've had a tough time setting up my replication server. Is there any program (OS X, Win, Linux or php no problem) that lets me monitor and resolve replication issues? (btw, for those -uhm- following, ive been on this issue here, here, here and here. Either i'm going about this the wrong way or i must be immensely thick) My production da...

What are the alternatives to using phpMyAdmin?

I've used phpMyAdmin for a while now - it gets the job done but it is very clunky and outdated, and has many features that I don't need. I'm looking for either a web based or (preferably) an OS X native alternative that is easy to use and isn't heavy on features. Is there any programs out there that fit the bill? ...

How to download a live MySQL db into a local test db on demand, without SSH?

I have a fairly small MySQL database (a Textpattern install) on a server that I do not have SSH access to (I have FTP access only). I need to regularly download the live database to my local dev server on demand; i.e., I would like to either run a script and/or have a cron job running. What are some good ways of doing this? Some points ...

How to know about memory consumption in mysql?

how can one know that each process or a thread is consuming how much memory in MYSQL? ...

MySQL 5.0 instance manager like functionality for earlier versions?

MySQL introduced a server side utility that lets you manage multiple instances on a remote machine. I am looking for similar functionality for earlier versions of mysql. [1]http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html ...

How do I restore a MySQL .dump file?

I was given a .dump MySQL database file that I need to restore as a database on my Windows Server 2008 machine. I tried using MySQL Administrator, but I got the following error: The selected file was generated by mysqldump and cannot be restored by this application. How do I get this working? ...

Best MySQL Server Monitoring Tool

I'd like some opinions about the best mysql monitoring tool available. I've tried MySQL Enterprise Monitor, and it is great for me except it's impossible to get MySQL sell something (see comments for details) - I'm ok to pay even if I find the pricing and bundling it with MySQL Enterprise only unreasonable. I am also looking at MONyog M...

How to monitor MySQL space?

I downloaded a VM image of a web application that uses MySQL. How can I monitor it's space consumption and know when additional space must be added? ...

MySQL field management

When I make a query, I often wonder about this: Is it better to add extra field(s) to the table, or just get the values and calculate in your server side language? For example, table Student contains Student.score field. I want to get the grades. Do I get the score and make a bunch of if/else/switch for the grades? ...

Autocomplete in MySQL under Windows

Does anybody know if there is a way to make autocompletion work in MySQL Command Line Client under Windows? It's working nicely under Linux for me, but simply moves the cursor under Windows instead. ...

MySQL permissions issue - should be non-issue

This is making me kind of crazy: I did a mysqldump of a partitioned table on one server, moved the resulting SQL dump to another server, and attempted to run the insert. It fails, but I'm having difficulty figuring out why. Google and the MySQL forums and docs have not been much help. The failing query looks like this (truncated for ...

Rather difficult mySQL problem ...

Hello there, A friend of mine is having an problem with an big mySQL database and quite a big number of repeating columns over multiple tables. To describe the problem better, the database serves multiple services like FTP, Postfix, webmail, pretty much all the common services you would be running on a general use Linux server and all ...

mysql query browser edit button disabled

Has anyone had this problem? I deleted a column in the table editor and then went back to MySql Query Browser but the edit button was disabled. Can't seem to figure it out and I hate MySql's forum format so i decided to ask here. Any help is greatly appreciated! ...

comparing data from mysql backups

I've got a few backups of my database, and I'm trying to figure out if there is a way to compare the data in the backups to see how the data as changed over time. I do not have a timestamp on the fields I want to compare, but I do have a unique id on the row. The backups are .sql files created by using mysqldump. Is there a process fo...

MySQL c++ how do I make a list of a list?

I am trying to build a table that has a value that is actually a second table and that table also has a value that is actually a third table. My end result needs to be representative of a C++ object that has an array of objects as one of its data types. I have thought using the value for the next layer object in MySQL as a reference to a...

How to make mysql accept connections externally

I have a VPS and I want to make mysql DB accept connection externally (from my PC for instance). I have Debian Linux installed on the server. I checked some tutorials online and they said to comment out: bind-address = 127.0.0.1 But this didn't seem to help! is there anything specific for VPSs? or Am I missing something else...

MYSQL Optimizing a table with 137000 rows

I'm trying to optimize a redmine database before it gets too much of a pain; the Changes (basically a log of all the SVN Changes) is at 137000 rows (ish) and the table is set to the b asic default settings. No key packing etc. The table is as follows ID int[11] Auto Inc (PK) changeset_id int[11] action varchar[1] path varchar[255] fro...

Mysql permission errors with 'load data'

I am running into a permission error when trying to load data from a flat file database dump into a new table. I know that the schema of the file and my table is the same and I tried tweaking the permissions. What else should I try? mysql> load data infile 'myfile.txt' into table mytable fields terminated by ',' enclosed by '"'; ERROR 1...

Moving Raw MYSQL Data Files to a Different Directory

I have a directory only backup of a previous server that hosted multiple sites. I had access to a few .sql backups for our databases, but there were some that had not been backed up in that fashion. I located the .MYD,.frm, and .MYI files for the tables in my db in the var/lib/mysql/db_name directory. I would like to know if there i...

Is there a faster way to load mysqldumps?

mysqldump is reasonably fast, but dumps of a medium-sized database (20-30 megs) take several minutes to load using mysql my_database < my_dump_file.sql Are there some mysql settings I can tune to speed up the load? Is there a better way to load saved data? I've experimented using the mysqlimport utility with CSV-based dumps. These loa...