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
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 the database, if you use
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 "mergin
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
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 o
- Original Message -
> From: "lejeczek"
> 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, dump then remove
> and
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 like
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
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 best.
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 (m
ens.
I'll 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 "
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'; datab
: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
>
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:
Sent: Saturday, March 08, 2008 6:58 AM
Subject: Can't drop database that shows
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 *
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
e 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 com
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 Mailin
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
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'
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 think I found it. The system has zlib 1.1.4 the sour
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 Fer
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) wrote:
Hi Bruce,
Do you have any messages in the
ginal 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 s
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) wrote:
Hi Bruce,
Do you have any messages in the MySQL log?
Re
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
---
-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. W
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 hav
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 seco
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 qu
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 the
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
ust 2005 9: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.
005 9: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
> 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 usi
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 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 M
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
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
, September 15, 2004 10:26 PM
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 d
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.
Wh
-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
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
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 dr
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
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 archi
I realised you weren't asking a question, 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
> > 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 con
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;
>+--+
>
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|
+--+
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 Mailing
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 fo
;drop" statements in one 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 q
rer / CEO iConnect GmbH <http://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, Decem
When you 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"
gs up.
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 ,
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
uccesfully
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/ say so).
Logging in to mysql with mysql -uroot -p to do the drop so it shouldn't be a user
permission i
a test then decided to delete it.
G> 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.
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 '
[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
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 real
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
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
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
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 usernames,
mysql command
line client (neither I was able to create database with that kind of
name):
ERROR 1064: You have an error in your SQL syntax near '12345' at line 1
>How-To-Repeat:
mysqladmin create 12345
echo "drop database 12345" | mysql
>Release:
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.
Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Mikel King
> Sent: den 25 januari 2001 09:14
> To: David Lidström
> Cc: Mysql@Lists. Mysql. Com
> Subject: Re: Drop Database
>
> Hi David,
>
> Have you tried D
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:
http://w
Lidström
Cc: Mysql@Lists. Mysql. Com
Subject: Re: Drop Database
Hi David,
Have you tried DROP DATABASE "\#Muffin" ; ?
Cheers,
Mikel
David Lidström wrote:
> Hi!
>
> I was testing some queries and now I've created a database
> named "#Muffin", and I c
Hi David,
Have you tried DROP DATABASE "\#Muffin" ; ?
Cheers,
Mikel
David Lidström 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 following:
&g
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
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
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 i
75 matches
Mail list logo
