Re: Can't get my query to return wanted data

On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote: > Hello Chris, > > On 1/19/2018 12:50 AM, Chris Roy-Smith wrote: >> Hi I am running mysql 5.7.20 in ubuntu linux 17.10 >> >> I have 2 tables, member and status with contents like >> >> member: >&

Can't get my query to return wanted data

for a selected year. select details.ident, given, surname from details left join status on details.ident = status.ident where NOT EXISTS (select year from status where (status.year = 2018) and (details.ident = status.ident) ) Thank you for looking at this. regards, Chris Roy-Smith -- MySQL General

Workbench MySQL Enterprise Backup Error

Hello all, I have not run across this problem where Workbench will not let me access the "Online Backup" link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is 4.0.0). I had backups running and scheduled through Workbench previously. Yesterday I changed my data files to

Re: can I just encrypt tables? what about the app?

On 29/02/2016 19:54, Gary Smith wrote: However, if TDE is employed, then you've got another significant obstacle to overcome: The data is only encrypted (aiui) once it's in memory. Apologies, that should read "unencrypted (aiui) once it's in memory" Gary -- MySQL General Ma

Re: can I just encrypt tables? what about the app?

On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. Once the disk is unencrypted, you've got access to the filesystem. If you've got physical access to the machine, then anything which gives you console access gives you (potentially) access

Re: dump, drop database then merge/aggregate

On 29/02/2016 16:32, Steven Siebert wrote: At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you use the --replace flag you'll convert all INSERT statements to REPLACE, which when you merge will update or insert the record, effectively

Re: dump, drop database then merge/aggregate

On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

Hi Neil, When you say you delete the current database, do you mean the database files only? Are you doing a complete restore? On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my >

Re: mysql dump global read lock

Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis

Re: Post-installation config and startup questions

Hi Steve, you haven't said what OS you are installing this on or how you have installed MySQL. Normally you would use a version avaialable in your OS distribution as this avoids any overly complicated installation and will manage security and bug patches for you MySQL binaries. Ie

Re: Merging multiple SQL requests

Learner Study learner.st...@gmail.com writes: Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters that may dictate that? I'm not sure what you could be meaning here... In the client protocol? to send

Re: Merging multiple SQL requests

Learner Study learner.st...@gmail.com writes: I meant that can MySQL server combine multiple responses for a client and send a single TCP packet back to the client. Unless there's a way to send multiple simultaneous requests, you won't get multiple responses in one packet. -- MySQL General

Re: Latency question - #of connections

Learner Study learner.st...@gmail.com writes: Setup: MySQL 5.6.16 + thread pool extensions running on 3.18 kernel Two sysbench clients running from different PCs with total of 14k connections, each connection doing 2 select queries per sec. When I specify 7k connections from each client,

Re: not replicating one table

Quoting william drescher will...@techservsys.com: I read the manual forwards and backwards but I can't figure out how to set it up to replicate everything except the in memory table. Is this what you are after?

Query

Hi, My name is Mia Smith and I manage the website Lacartes.com. We are expanding our online marketplace in your area and I was wondering if you'd like to add your business to our website for free? Our website is helping 400,000+ people every month find the businesses, products and services

Re: Can't Connect Localhost

Connect Localhost To: mysql@lists.mysql.com Cc: John Smith cantinaderecuer...@yahoo.com Date: Sunday, 1 September, 2013, 3:33 AM Hi John, Starting over…. What is the error message? Terry ___ Terry J Fundak Systems Engineer Network Design

Re: Can't Connect Localhost

On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 1:34 PM where you can change this? typically in the config file of teh software without

Re: Can't Connect Localhost

On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 2:44 PM I looked in mysql.config.pl and no localhost :( mysql.config.pl from what

Can't Connect Localhost

Hi; How do I change my connection from localhost to 127.0.0.1 on a Win8 machine? TIA, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Rookie question

On 29/04/2013 18:29, Patrice Olivier-Wilson wrote: Hi all: I have a membership directory where folks can belong to more than one category. But all folks do not qualify for a category. So I want to list folks who have qualified in a category but not have them repeat. So if member 1 is in cat 3

Re: Can the mysql replication limited to one database

Quoting Brown, Charles cbr...@bmi.com: Can the mysql replication limited to selected schema or database? Hi, yes it can. On the master side you control what is written to the binlog with my.cnf entries for each DB like: binlog-do-db=DB1 binlog-do-db=DB2 And on the slave side you use

Re: Postal code searching

On 24/04/2012 17:11, Tompkins Neil wrote: Hi I've a number of different postal codes in a system for example WC1B 5JA WC1H 8EJ W1J 7BX W1H 7DL NW1 1NY I can use like statements for example SELECT * FROM postal_codes WHERE zip LIKE 'W1%' giving me W1J 7BX W1H 7DL In addition I have a number

Re: Postal code searching

On 24/04/2012 17:16, Gary Smith wrote: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html Specifically, replace % with _ as this means match one character not match any number of characters. So, you can do: like W1 % like W1_ % etc. Oh, and you can also get really dirty

Re: Postal code searching

On 24/04/2012 17:24, Tompkins Neil wrote: How about if I want to only return postal codes that are like W1U 8JE not W13 0SU. Because in this example I have W1 as the postal code and W13 is the other postal code Then you'd do: like 'W1 %' to return anything starting W1 like 'W13 %' to return

Re: a sql injection attempt

On 13/02/2012 22:09, Haluk Karamete wrote: Gary, you've mentioned that the user would have had access to the sysobjects No, there's a difference. *If* they had access to sysobjects then it could've caused issues. Ideally, you should have some level of segregation within your database. That

Re: a sql injection attempt

On 13/02/2012 21:48, Haluk Karamete wrote: My logs shows that we have tried with a SQL Injection attempt, but our engine has detected and avoided it but I am just curious, what are these SQL statements are intending to achieve? SELECT * FROM lecturer WHERE recID='25 ' and exists (select *

Re: MySQL daemons restarting every 7 minutes

This was me restarting MySQL as was requested by Suresh... Quoting Singer X.J. Wang w...@singerwang.com: This doesn't look like a MySQL issue. Verify that there's no rogue scripts that shutdowns MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: MySQL daemons restarting every 7 minutes

Ok, this is pretty odd but I have found the problem. Today I have repointed all applications to a different DB server, so I have been free to do any testing on the problem server. I started by dropping the databases one by one, dropped em all and the issue persisted. I stopped crond, even

Re: MySQL daemons restarting every 7 minutes

Quoting walter harms wha...@bfs.de: What i found odd that your mysqld actualy restarts. Do you have it in some runlevel ? if yes stop and see what happens. If this does not work simple move the mysqld out of he way and replace it with a script like #!/bin/sh echo mysqld ... | logger -t TEST

Re: MySQL daemons restarting every 7 minutes

Quoting Reindl Harald h.rei...@thelounge.net: Odd that, so I added a mysql specific line to the hosts.allow who is using hosts.allow for protection instead a firewall in front of the machine or iptables (linux) / ipf (bsd)? Its used for denyhosts as I mentioned. As I said I can get it

Re: MySQL daemons restarting every 7 minutes

Quoting walter harms wha...@bfs.de: I still do not see why it is restarting ... there must be something watching is disappear. Just to be sure, you do from a remote host: mysql -hHOST -ume -e show tables ? long shot: Do you have LDAP, NIS or so enabled ? Ok so made a script as you

Re: MySQL daemons restarting every 7 minutes

Quoting walter harms wha...@bfs.de: restart it with the same parameter on the command line and see what happens the server support a verbos option (never used) perhaps it will tell you more. I can start mysqld direct from the command line and reproduce the problem. I checked and it

Re: MySQL daemons restarting every 7 minutes

Quoting Reindl Harald h.rei...@thelounge.net: You are not welcome to use mysqld from tau is NOT from mysqld remove your hosts.allow/hosts.deny crap and replace it with firewall-rules if the problem goes away make a bugreport on BSD side becahuse this is NOT a mysqld issue I've already

Re: MySQL daemons restarting every 7 minutes

Hi Walter/all, ok nailed it, the issue is the default hosts.allow installed on FreeBSD, and specifically the last section that denies everything. By default it looks like this: # The rest of the daemons are protected. ALL : ALL \ : severity auth.info \ : twist /bin/echo

Re: MySQL daemons restarting every 7 minutes

Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier

Re: MySQL daemons restarting every 7 minutes

Yep, but its basically identical to the info in the logs when its restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so the error info differs due to the version now. Here is the log output: 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

Re: MySQL daemons restarting every 7 minutes

No need for that really is there? I posted what was requested. The part for the shutdown: 110909 17:27:31 InnoDB: Starting shutdown... 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 110909 17:27:32

MySQL daemons restarting every 7 minutes

Hi, as of yesterday the MySQL Daemons keep restarting every 7 mins or so on one of my FreeBSD servers. The only work carried out recently related to MySQL on this server was to temporarily disable replication (its a slave) of one DB, and then re-enable it (via restore of data and

Re: very large import

Quoting supr_star suprstar1...@yahoo.com: Is there any way to speed up this process? by disabling indexes or something?  I can't afford to be down for 3 more days...   First stop, the mysql documentation: http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html -- MySQL General Mailing

Re: corrupt innodb database

Quoting supr_star suprstar1...@yahoo.com: This db is on its own partition, so I can't delete logs or anything else to clear up space.  So I moved ib_logfile0 and ib_logfile1 This is a really bad idea as will break all ur InnoDB databases. Do you have space elsewhere on other partitions on

Re: corrupt innodb database

PS and put back the two log files you moved. PPS if you don't have any space currently to do what I suggested then at least softlink the log files from /tmp to their original locations. Quoting a.sm...@ukgrid.net: Quoting supr_star suprstar1...@yahoo.com: This db is on its own partition,

Re: Too many active concurrent transactions

Quoting Angelo Vargas ang...@at.com: I keep getting this error when we get spikes in traffic. Even though max connections is set to 4096 and file limits are raised, mysql still gives this error. Is there a setting I should be looking for that will allow me to raise whatever causes this error?

Re: Cópia rápida do DB com tabelas MyISAM e InnoDB para outra servidor

Hi, if you want to copy from one server to another can't you just use mysqldump? This is then restored via the mysql command using a pipe or STDIN redirection. If you can shutdown the database for the duration of the copy then you can do cold backup of all data files. Both options will

Re: Cópia rápida do DB com tabelas MyISAM e InnoDB para outra servidor

Quoting Yoshio geanyos...@gmail.com: I can use mysqldump but its take many hours to complete a restore. I can stop the server, so i'm think in a physical copy of the database. But I have not found the innodb files. Where are that files? InnoDB is a bit tricky, without going into details (I

Re: Cópia rápida do DB com tabelas MyISAM e InnoDB para outra servidor

Quoting Yoshio geanyos...@gmail.com: I found the ibdata and logfiles, but outside from my database dir. so basically I need copy everything in /var/lib/mysql/* ? Yeah that's normal, they will be in the top level of your MySQL datadir. Yep, copy everything. As I said, if you have any

Re: Deleting of records older than a specific date time

Quoting Machiel Richards machi...@rdc.co.za: We need to be able to delete all data from the 2 tables that is older than the start of yesterday. Hi, I use this ver simple script to purge data from a syslog DB: #!/usr/local/bin/bash /usr/local/bin/mysql -u syslog -pmypasswd

Re: Backup Policy

Hi, there is a lot of info on different backup methods here: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html For example, for incremental backups see Making Incremental Backups by Enabling the Binary Log, cheers Andy. -- MySQL General Mailing List For list archives:

managing a foreign key constraint over two databases

Good afternoon, I am beginning to scale out my database and I have the following problem, which I'm sure is common enough, but I suspect, having done some reading, that there a few possible solutions. Replication and XA transactions spring to mind, for example. Please bear with me. This is my

Re: mysqldump except one table

Check the manual? Its here under ignore-table http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Quoting Adarsh Sharma adarsh.sha...@orkash.com: Dear all, I am researching about different parameters provided by the *mysqldump* utility. It provides a method to dump databases with all

Re: MySQL replication server

Hi, I think you are wrong, slaves will always accept writes unless you set readonly in the mysql config. Due to this, and if you dont specifically set readonly on the slave you have to be very careful in order to maintain data integrity on the slave and also not to break repliacton.

Re: MySQL replication server

Hi, so yes you can do that, but then I guess you cannot set the server hosting database A as readonly (from memory this can only be set server wide, but worht checking it out). Which might leave you a few options to ensure data integrity, for example simply by user security either by

Re: Failover on master/slave replication

Quoting Machiel Richards machi...@rdc.co.za: The question I have however is how do you fail over to the slave server in the event that the master server is unavailable and then how to revert back to the master server once the server is available again. Hi, to fail over to the

Re: Backing up the InnoDB tables

Quoting Tompkins Neil neil.tompk...@googlemail.com: The problem is I don't have any command line access, just direct MySQL access to the database tables. I dont know xtra backup, but if thats not an option you can just use mysqldump. This can be run from a remote server to your DB server,

Re: Replication / standby option on MySQL (GA)

This is in the GA (free) release and has been for many years I believe... Quoting Machiel Richards machiel.richa...@gmail.com: Hi Guys Can someone please confirm whether replication / standby functionality is available on the GA release of MySQL or this an Enterprise specific

Re: document for mysql performance improvement

If its an IO problem the first and easiest thing to do is (probably) look at your disk subsystem. You can easily achieve higher disk IO by increasing the number of disks and implementing something like RAID1+0. What is your current disk configuration? Andy. -- MySQL General Mailing

Re: document for mysql performance improvement

Quoting vokern vok...@gmail.com: The disk is exactly Raid10. The CPU is two 2.5G*4, totally 16G memory. And how many disks do you have, and what type (SATA/SAS/FC etc) what RPM? To improve IO you can add more disks, or upgrade to faster disks. -- MySQL General Mailing List For list

Re: document for mysql performance improvement

Quoting vokern vok...@gmail.com: Two disks with SAS driver, 15K rpm. Ok so you have fast disks, but with only 2 disks it is normal you will be quite restricted by DISK IO. By adding more in multiples of 2 and stripping across all you achieve RAID1+0 and higher max IO... Andy. --

Re: document for mysql performance improvement

Quoting Johan De Meersman vegiv...@tuxera.be: Your raid controller is lying to you - you can't have RAID10 with just two disks :-p Don't worry about that, though - it's a good enough config. Good enough? If he is genuinely saturating the disk with IO (as he states the problem is IO) then

Re: clone a database on the same machine

That entirely depends on your requirement, if you need it to be accessible with the same username and password, then configure it with the same username and password. thanks Andy. Quoting Uwe Brauer o...@mat.ucm.es: On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman vegiv...@tuxera.be

Re: Crashed Table - How to report/prevent?

Why not use the mysql tool, mysqlcheck: http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication VS Cluster

Clustering is a general term, do you know which one you are comparing with replication? Clustering most typically refers to high availability clustering or high performance clustering, which wouldnt necessarily/normally imply any copy of the actual data. If you want a copy of your data on

Re: Replication VS Cluster

Quoting Jangita jang...@jangita.com: Simply put: I want a solution that ensures that server 2 has all the data at server 1 at any point in time; say server 1 suddenly fell into a pond :) . I wouldnt want to open server 2 and find the last insert/update/delete missing... Ok so that

Re: master-slave replication sync problems.

That is really bad, you will loose changes. You shouldnt have to do anything when rebooting either the master or slave. If the master is down, then the slave recieves no updates. If the slave is down, when it comes back up it checks the master log pos and plays thro any changes that are

Re: master-slave replication sync problems.

Quoting Norman Khine nor...@khine.net: i see, so the best is to just stop slave and then check the master status, and when the master status syncs then i start the slave? Well Im willing to hear from others experiences, but if you really shouldnt have to do anything. If you want you can

Re: master-slave replication sync problems.

Quoting Ananda Kumar anan...@gmail.com: Smith, I never said, this wont work.Some times, there are chances of lossing data. regards anandkl If you have experience of this fair enough. Theres no reason it should make any difference, as everything is based upon the binlog file

Re: master-slave replication sync problems.

Quoting jitendra ranjan jitendra_ran...@yahoo.com: Hi,   The best way to use sync the master and slave is using mk-checksum tools. just google it and use the the tools for online sync of master and slave.   Jeetendra Ranjan MySQL DBA Yes, data integrity isnt guaranteed with MySQL

Re: Creating a dedicated reporting server for management?

Run something like Solaris zones, or FreeBSD jails? Then u can have multiple masters... Quoting Nunzio Daveri nunziodav...@yahoo.com: Hello Gurus, I have a customer who wants to create a reporting server for his management team. He wants to take server 1,2,3 and move the 3 databases from

Re: help with replication

Quoting Norman Khine nor...@khine.net: hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. What is shown from show master status and show slave status

Re: help with replication

Quoting Norman Khine nor...@khine.net: What is shown from show master status and show slave status after you have made a change on the master DB? this is the output: http://pastie.org/1100610 it does not seem to have any changes and show slave status is just empty. have i missed to add

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

Google? http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-ssl.html This is for MySQL 5.1, I imagine its probably the same in 5.1 but another little google should be able to confirm that for you Quoting Tompkins Neil neil.tompk...@googlemail.com: Hi, We are running Ubuntu

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

According to this you must install OpenSSL then compile MySQL from source http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html Would be nice if someone on the list with prior experience would comment Quoting Tompkins Neil neil.tompk...@googlemail.com: Hi I found this

Re: Table Consistency/analize/check/repair

this built in command is probably a good start: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: source backup.sql - troubleshoot

Quoting Sydney Puente sydneypue...@yahoo.com: Hello, I have a mysqldump file created by AutoMySQLBackup. And it hangs when I do a mysql source backup.sql If you are trying to restore from backup.sql to a database called soure then your syntax is wrong. You should be running: mysql

Re: source backup.sql - troubleshoot

Quoting Johan De Meersman vegiv...@tuxera.be: On Wed, May 26, 2010 at 10:20 AM, a.sm...@ukgrid.net wrote: If you are trying to restore from backup.sql to a database called soure then your syntax is wrong. You should be running: mysql source backup.sql You are assuming that the file named

Re: (followup) Important for users of Bazaar branches of MySQL Server code from Launchpad

On Mon, 24 May 2010 10:45:30 +0200, Guilhem Bichot guil...@sun.com wrote: bzr branch lp:mysql-server/trunk mysql-trunk Download was 200MB. ~20minutes on ADSL from Australia bzr using 100% CPU bzr using ~600MB RAM -- Stewart Smith -- MySQL General Mailing List For list archives: http

Re: Tokutek Acquires Oracle

Krishna Chandra Prajapati wrote: Hi guys, Is the information is true. http://planet.mysql.com/ http://tokutek.com/2010/04/tokutek-acquires-oracle/ Might want to check the date. Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: table export in cron

machiel.richards wrote: How can we do this when running in a cron script? mysql -e select * from table into outfile '/path/to/output/file' fields terminated by '|' ? Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Render row without duplicates

bharani kumar wrote: Hi My fields something like hospital1,hospital2,hospital3,patientname, [...] i know , i can display all hospital code with unique , but i dont in the single column , with unique record, Can you tell me how to do this ? Would it be possible to reconsider your

Re: Render row without duplicates

Benedikt Schackenberg wrote: Am 02.01.2010 13:43, schrieb bharani kumar: No Duplicate records, select hospital1code from *yourtable* grop by hospital1 This won't work as he's also looking for entities in the hospital2code and hospital3code fields to be returned in the same resultset, but

Re: Importing table contents

Patrice Olivier-Wilson wrote: I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But when I run that operation, the

Re: Importing table contents

Patrice Olivier-Wilson wrote: I have data I need to keep in both db just trying to merge. There's two ways around this: First is to not export the structure (uncheck structure). The second is to export with if not exists. This should (IIRC) do a create table if not exists, so it'll do

Re: Importing table contents

Patrice Olivier-Wilson wrote: Gave it a try got this: MySQL said: #1062 - Duplicate entry '1' for key 1 Yeah, that's what I was saying about in my previous mail. It looks like you've got a primary key on one of your columns, and you're attempting to insert data into it with a duplicate

Re: Database fundamentals: wanna learn.

Ken D'Ambrosio wrote: Hey, all. I've been using databases clear back to xBase days; that being said, I've never had a solid foundation for relational databases. While I can muddle by in SQL, I really don't have a good understanding of exactly how keys are set up, the underpinnings of indexing,

Re: last_insert_id

Victor Subervi wrote: On Sun, Dec 27, 2009 at 12:00 PM, Michael Dykman mdyk...@gmail.com wrote: last_insert_id() returns the last id auto-incremented in *the current session*. If you disconnect and reconnect, it can not be retrieved. Ahah! So how do I retrieve the last id inserted

Re: last_insert_id

Steve Edberg wrote: (2) autoincrement values are not reused after deletion, so if you deleted the record with ID=1000 inserted in (1), the next autoincrement would still be 1001, even if the existing records are IDs 1,2,3. This is usually the desired behavior, but again, may not be what *you*

Re: all tables with certain type

walter harms wrote: hi list, is it possible to get a list of all tables with a certain type in one statement ? for now i collect all tables (show tables) and search for the type (show columns). Any way to circumvent that ? make it one statement ? use information_schema; select

Re: Multiple joins from same table?

Terry Van de Velde wrote: Good Day, I am attempting to do something new (to me) with MySQL. I am looking to have my query return with the value in the visitor and home columns replaced with the corresponding team name from the teams table. schedule.visitor and schedule.home are essentially

Re: MySQL being hacked with commands through URL

James Coffman wrote: Hello all, My website has been hacked using a url such as: -1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f rom%20users-- . I have been searching on the web for a solution/fix to this issue and I cannot seem to find one. The

MySQL Server 5.4.3-beta has been released

/refman/5.4/en/news-5-4-3.html Enjoy! Timothy Smith The MySQL build team at Sun Microsystems == Functionality added or changed: * Incompatible Change: If you upgrade to MySQL 5.4.3 from an earlier 5.4 release, the server may fail to start due to changes in the default values

MySQL Server 5.1.37 has been released

) * Renaming a column that appeared in a foreign key definition did not update the foreign key definition with the new column name. (Bug#21704: http://bugs.mysql.com/21704) -- Timothy Smith, Release Engineering, MySQL Database Technology Group, Sun Microsystems -- MySQL General Mailing List

RE: Slave log files going nuts...

-Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Friday, July 17, 2009 2:02 PM To: Gary Smith; Todd Lyons Cc: mysql@lists.mysql.com Subject: RE: Slave log files going nuts... The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or when

Slave log files going nuts...

I have a new slave I setup against a new master server. The master server has 4 log files in it, the most current being updated on the 16th. The slave server on the other hand has several files, many which seem to be blank. This slave is set to slave the master and act as a master for

RE: Slave log files going nuts...

] On Behalf Of Todd Lyons [tly...@ivenue.com] Sent: Thursday, July 16, 2009 2:41 PM To: Gary Smith Cc: mysql@lists.mysql.com Subject: Re: Slave log files going nuts... On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote: I have a new slave I setup against a new master server

RE: Copy 70GB ibdata, etc. and server won't start now

, the startup recovery flags might be your best bet. From: Daevid Vincent [dae...@daevid.com] Sent: Tuesday, July 14, 2009 12:23 PM To: mysql@lists.mysql.com Cc: Gary Smith Subject: RE: Copy 70GB ibdata, etc. and server won't start now -Original Message

RE: Copy 70GB ibdata, etc. and server won't start now

? If this were a hot backup, I could see this problem happening. If it were a could backup, it should work. From: Johnny Withers [joh...@pixelated.net] Sent: Tuesday, July 14, 2009 1:40 PM To: Daevid Vincent Cc: mysql@lists.mysql.com; Gary Smith Subject: Re: Copy 70GB

RE: Copy 70GB ibdata, etc. and server won't start now

InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. InnoDB: Error: trying to access page number 2144600306 in space 0,

RE: Replication, Stored Proceedures and Databases

-Original Message- From: sjm...@pobox.com [mailto:sjm...@pobox.com] Sent: Saturday, July 11, 2009 1:02 AM To: mysql@lists.mysql.com Subject: Re: Replication, Stored Proceedures and Databases g...@primeexalia.com (Gary Smith) writes: ... In database G we have 150+ stored

RE: Re: Replication, Stored Proceedures and Databases

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Saturday, July 11, 2009 2:44 AM To: Simon J Mudd Cc: mysql@lists.mysql.com Subject: R: Re: Replication, Stored Proceedures and Databases You dont have changes coming from db G since it is ignored from

Crazy replication problem

Here is steps take to get to the problem. Version is 5.1.35 To be on the safe side, I did this prior to executing the scripts. I deleted the mysql directory and the mysql-log directory, recreated them, chowned them, ran mysql_install_db, chowned them again. So, I know at least I'm working

RE: Crazy replication problem

though the tables are qualified. Can anyone confirm this? Gary From: Gary Smith [g...@primeexalia.com] Sent: Friday, July 10, 2009 5:12 PM To: mysql@lists.mysql.com Subject: Crazy replication problem Here is steps take to get to the problem. Version

  1   2   3   4   5   6   >