Re: dump, drop database then merge/aggregate

Ah, ok, if I understand correctly within this context every record in the one table _should_ have a unique identifier. Please verify this is the case, though, if for example the primary key is an auto increment what I'm going to suggest is not good and Really Bad Things will, not may, happen. If

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote: > 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

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/16 16:32, Steven Siebert wrote: What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively

Re: dump, drop database then merge/aggregate

What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively manually doing replication? I agree with

Re: dump, drop database then merge/aggregate

- Original Message - > From: "lejeczek" <pelj...@yahoo.co.uk> > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again,

Re: dump, drop database then merge/aggregate

On 29/02/16 15:42, Gary Smith wrote: 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

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: dump, drop database then merge/aggregate

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 done and I wonder how it's done

dump, drop database then merge/aggregate

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 done and I wonder how it's done best. A box will be dumping a database

Can't drop database that shows up in show databases

SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist When I run any queries on that database, I get errors like: mysql select * from Users; ERROR 1017 (HY000): Can't find file

Re: Can't drop database that shows up in show databases

Waynn- does the OS user you use to execute mysql have create/write/read/execute rights to the ./test folder? Martin- - Original Message - From: Waynn Lue [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 08, 2008 6:58 AM Subject: Can't drop database that shows up in show

Re: Can't drop database that shows up in show databases

:58 AM, Waynn Lue [EMAIL PROTECTED] wrote: SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist When I run any queries on that database, I get errors like: mysql select

Re: Can't drop database that shows up in show databases

Hi, On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue [EMAIL PROTECTED] wrote: SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist When I run any queries on that database, I get

Re: Can't drop database that shows up in show databases

post back with results. Thanks for all the advice, Waynn On 3/8/08, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue [EMAIL PROTECTED] wrote: SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get

DROP DATABASE

hi all, Does drop database command removes all the users permissions related with that databases or those user permissions has to be revoke manually. Regards, Krishna

Re: DROP DATABASE

Hi, Does drop database command removes all the users permissions related with that databases or those user permissions has to be revoke manually. DROP DATABASE does not remove the privileges. You have to remove that separately. Best regards, Aleksandar -- MySQL General Mailing List

Re[2]: DROP DATABASE

Hi, What will be the impact if i don't remove the users privileges. Does mysql will restart successfully or not. OR should i remove the users privileges before dropping the database. It will restart sucessfully. The only impact I can see is that next time a database with the same name is

Re: DROP DATABASE

the users privileges. Does mysql will restart successfully or not. OR should i remove the users privileges before dropping the database. Please guide me. Regards, krishna On 8/17/07, Aleksandar Bradaric [EMAIL PROTECTED] wrote: Hi, Does drop database command removes all the users permissions

weird drop database error

We are getting a weird DROP DATABASE error 2007-06-10 11:25:41 db 527 DEBUGDROP DATABASE BCS OperationalError: (1051, Unknown table 'assignments,chemo,choicelists,dia,forms ,horm,id,permissions,qhistory,qnotes,qstates,questionnaires,r') the thing is, there is NO table 'r' ... can't tell

DROP DATABASE weirdness

I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second

RE: DROP DATABASE weirdness

To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any

Re: DROP DATABASE weirdness

--- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I

RE: DROP DATABASE weirdness

PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide

Re: DROP DATABASE weirdness

@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards

Re: DROP DATABASE weirdness

Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol

Re: DROP DATABASE weirdness

@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards

RE: DROP DATABASE weirdness

PROTECTED] Sent: Thursday, 30 November 2006 11:17 AM To: mysql@lists.mysql.com Cc: Logan, David (SST - Adelaide) Subject: Re: DROP DATABASE weirdness Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I

Re: DROP DATABASE weirdness

@lists.mysql.com Cc: Logan, David (SST - Adelaide) Subject: Re: DROP DATABASE weirdness Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3

mysql crashes on drop database?

that attempting to drop the first database causes mysql to crash. There are about seven or eight tables in said database, mostly empty, with about five or six records total in the database in question mysql drop database AccountingAdminDB; ERROR 2013 (HY000): Lost connection to MySQL server during query

DROP DATABASE doesn't actually drop the database?

run it once (if I close the Query Browser and then open it again and reload the script later), I get error 1061 Duplicate key name on all of the indices. So I figured I missed something, and I'll just DROP the whole database and then run the script. I add a DROP DATABASE databasename; and a CREATE

Re: DROP DATABASE doesn't actually drop the database?

Thanks for your comments! I ran my entire script (DROP DATABASE and all) with the command-line client, and got no errors. Perhaps there is something with the Query Browser that is causing this problem. I added the IF EXISTS and IF NOT EXISTS in appropriate places (although I can see

Re: cannot drop database

:09 AM To: mysql@lists.mysql.com Subject: cannot drop database I need to drop a database named ÃáãÃáà using the mysql client. I'm getting you have an error in your sql syntax for the command DROP database ÃáãÃáÃ; I'm sure this is a character set issue. How can I drop this database

Re: cannot drop database

Try DROP database `ÃáãÃáÃ`; Gary Huntress wrote: I need to drop a database named ÃáãÃáà using the mysql client. I'm getting you have an error in your sql syntax for the command DROP database ÃáãÃáÃ; I'm sure this is a character set issue. How can I drop this database? Regards

Re: cannot drop database

I need to drop a database named ÃáãÃáà using the mysql client. I'm getting you have an error in your sql syntax for the command DROP database ÃáãÃáÃ; I'm sure this is a character set issue. How can I drop this database? What about using backticks around it: drop database

RE: cannot drop database

:09 AM To: mysql@lists.mysql.com Subject: cannot drop database I need to drop a database named ÃáãÃáà using the mysql client. I'm getting you have an error in your sql syntax for the command DROP database ÃáãÃáÃ; I'm sure this is a character set issue. How can I drop this database

cannot drop database

I need to drop a database named ÃáãÃáà using the mysql client. I'm getting you have an error in your sql syntax for the command DROP database ÃáãÃáÃ; I'm sure this is a character set issue. How can I drop this database? Regards, Gary H. -- MySQL General Mailing List For list

Re: drop database after lost of synchro in innodb

Johanne, DROP DATABASE is rather safe, if it succeeds. http://dev.mysql.com/doc/mysql/en/InnoDB.html is the best reference. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up

Re: drop database after lost of synchro in innodb

Subject: drop database after lost of synchro in innodb --_=_NextPart_001_01C49B59.D21B539E Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello =20 I am trying to drop a database but I have the following: ERROR 1016: = Can't open file

Re: drop database after lost of synchro in innodb

viesti - Lähettäjä: Duhaime Johanne [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Thursday, September 16, 2004 3:27 PM Aihe: RE : drop database after lost of synchro in innodb Thank you for your answer. But both frm and ibd exist for every tables. I tried

drop database after lost of synchro in innodb

Hello I am trying to drop a database but I have the following: ERROR 1016: Can't open file: 'Alias.InnoDB' (errno: 1) In fact it looks like the synchro is lost between FRM and IBD. (I use a multiple tablespace configuration) according to http://www.innodb.com/ibman.php section 15.1.

Drop database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In mysql 4.0.18 I have a database with innodb tables and foreign keys. I need to drop / recreate the database for testing purposes. When I enter the command drop database xxx I get an error message indicating a foreign key violation. As I

Can't drop database

Hi I am running Suse Linux 8.2 and MySQL 3.23.55 A funny thing happens: % mysqladmin drop base Database base dropped % mysqladmin create base Can't create database 'base'. Database exists. And if I log in to MySQL, there it is - undropped! So why is mysqladmin telling me the database is

Re: Can't drop database

When you DROP DATABASE 'base', mysql drops all its tables then drops the db. At the filesystem, this means deleting all the table files from the 'base' subdirectory of mysql's data directory, then deleting the 'base directory itself. If 'base' contains a file that isn't a table file, however

can't drop database: ERROR 1217

version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686) mysql DROP DATABASE xxx; ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails what is this all about? how the heck can I drop the database? Dean Hoover -- MySQL General Mailing List For list archives

RE: can't drop database: ERROR 1217

Dean, Seems your database has a table with foreign key constraints. You need to delete that table first and then you will be able to drop database successfully. Hope that helps!!! Raza -Original Message- From: Dean A. Hoover [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 4:13

'drop database' failing silently?

Hi all, this morning, I had a problem dropping a database from within mysql. mysql drop database mis; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | mis | | mysql| +--+ 2 rows

Re: 'drop database' failing silently?

Kevin O' Riordan [EMAIL PROTECTED] wrote: this morning, I had a problem dropping a database from within mysql. mysql drop database mis; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | mis | | mysql

Re: 'drop database' failing silently?

this morning, I had a problem dropping a database from within mysql. Are there any non-mysql files in the directory of the database 'mis'? Should've added this. There was only one file in the 'mis' directory: -rw-rw-rw-1 mysqlmysql 44 Apr 30 09:51 file.out Which

Re: 'drop database' failing silently? - solved.

, but rather giving an answer. In case it's of any use to anyone else here: if a database's dir contains non-database files, the dir will not be removed following a 'DROP DATABASE'. thanks Victoria! -kev -- My lord, this is our first offense, but not our last. If you will be easy

1051: Unknown table on running drop database

I'm getting this error: ERROR 1051: Unknown table '#sql-279_28,#sql-333c_1' after trying to drop a database. I found nothing in the docs or the archives about how to sort it out. Can anybody tell me what steps I should take to remedy this? I'm using 4.1.0 Thanks, Adam -- MySQL General

RE: style question: drop database in an install script

script, all my create scripts in another, and all my populate scripts in yet another. Arthur -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 8:15 PM To: mysql users Subject: style question: drop database in an install script -BEGIN PGP

Re: style question: drop database in an install script

Arthur, et al -- ...and then Arthur Fuller said... % % I don't know about anyone else, but for this sort of thing I love the % program called DeZign, which is a data-modeling tool. You can draw your % tables and their columns and set up relations and so on. DeZign will then % write your code for

Re: style question: drop database in an install script

experienced folks write software that's meant to be % installed from a script or such, do you lead off with a 'drop database' % command, or is that just too dangerous to put in a script % % I would think so. I'm going to figure you think too dangerous rather than think lead off based on your comments

Re: style question: drop database in an install script

://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 2:15 AM Subject: style question: drop database in an install script

style question: drop database in an install script

. The script starts out drop database if exist dbname ; create database dbname ; use dbname ; create table tablename ( ... ) ; ... to set things up and then continues insert into tablename (field,field,field) ( data , data , data ) , ... ( data , data , data

Bug in drop database mysql 4.0.1-2

I posted a couple of days ago on what appears to be a bug in drop database of mysql-max-4.0.1-2. Here is a recipe to see if others are seeing the same problem. This is on Red Hat Linux 7.2 and is extremely repeatable nor is it limited to a single linux box (ie. not likely hardware problem

Unable to drop database

succesfully remove the database it's just the mysql client has the problem. drop database returns ok but the database is still there (both show databases and ls -al /var/lib/mysql/dbname say so). Logging in to mysql with mysql -uroot -p to do the drop so it shouldn't be a user permission issue

Re: DROP DATABASE executes but fails to remove database!

I used the command: DROP DATABASE 'xzy';which returns a message that G the command executed successfully, affecting however many rows were in the G database at the time. G SHOW DATABASES; shows that the database is still there. G I then re-tried using command: DROP DATABASE if exists 'xyz

DROP DATABASE executes but fails to remove database!

Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present, can't check actual version number. Installed, running and everything is ok, except I created a database called 'xyz' as a test then decided to delete it. I used the command: DROP DATABASE 'xzy';which returns

Couldn't Drop database

After I've dropped the database using mysqladmin, the following message appeared: %mysqladmin drop databasename Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you

Re: Couldn't Drop database

[EMAIL PROTECTED] wrote: After I've dropped the database using mysqladmin, the following message appeared: %mysqladmin drop databasename Dropping the database is potentially a very bad thing to do. Any data stored in the

Re: How to drop table from InnoDB after drop database from MySQL?

Dave, DROP DATABASE for InnoDB type tables is in my TODO list for August, and I am determined that the September distribution will have it implemented. But meanwhile, if you accidentally lose the .frm file of your table, but the table still exists inside InnoDB, you can use the following trick

How to recover from accidental 'drop database mysql'

Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able to login, probably because mysql server caches

RE: How to recover from accidental 'drop database mysql'

Hi, Its called your backup tape. Quentin -Original Message- From: Anonymous Individual [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 4:16 p.m. To: [EMAIL PROTECTED] Subject: How to recover from accidental 'drop database mysql' Greetings: I accidently dropped (my thunderous

Re: How to recover from accidental 'drop database mysql'

On Mon, 2 Apr 2001, Anonymous Individual wrote: Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able

Drop Database

Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Ple

Re: Drop Database

David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check: http://www.mysql.com

RE: Drop Database

Hi! Yes, it is a database. I recieve these errors, regardless if I use the semi-colon: Query: DROP DATABASE #Muffin Returns: ERROR 1064: You have an error in your SQL syntax near '' Query: DROP DATABASE '#Muffin' Returns: ERROR 1064: You have an error in your SQL syntax near

RE: Drop Database

ysql@Lists. Mysql. Com Subject: Re: Drop Database Hi David, Have you tried DROP DATABASE "\#Muffin" ; ? Cheers, Mikel David Lidstrm wrote: Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the foll

RE: Drop Database

Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - Before posting, please check:

RE: Drop Database

To: [EMAIL PROTECTED] Subject: RE: Drop Database Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover