QxOrm manual (https://www.qxorm.com/qxorm_en/manual.html#manual_95
<https://www.qxorm.com/qxorm_en/manual.html#manual_95>) and new sample
project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now
available on GitHub (official repository) : https://github.com/QxOrm/QxOrm
tion amongst InterBase and Firebird database developers,
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL
Server.
s out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this issue, so that above error
disappears permanently? Is it a database issue or applica
-sync.html
http://stackoverflow.com/questions/15798762/mysqli-commands-out-of-sync-you-cant-run-this-command-now
On Friday, January 8, 2016 10:47 AM, geetanjali mehra
wrote:
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can'
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this
ndows through any number of ssh clients,
not just the one that comes with Cygwin.
Granted, one advantage of running Cygwin on user's host machine is that
you give them a local bash shell to work from but once you hop boxes
(via ssh) and are now 'local' to the production server, that ad
MG>My development is identical ..Development on Windows..Production on Linux
MG>When google routes me to Vladimir Putins site for "Official Windows Mysql
Stack" you download god knows what
MG>solution is to give the customer an in-between solution such as mysqld,
mysqladmin and mysql shell sc
> From: m.ton...@upscene.com
> To: j...@ecoreality.org; mysql@lists.mysql.com
> Subject: Re: database developer tool "Database Workbench 5" now available
> Date: Fri, 5 Sep 2014 07:57:37 +0200
>
> Hello Jan, list,
>
> >> From: "Martijn Toni
Hello Jan, list,
From: "Martijn Tonies (Upscene Productions)"
Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!
Unless you don't do Winblows.
Please put Windows dependency clearly in your annou
> From: "Martijn Tonies (Upscene Productions)"
>
> Database Workbench now comes in multiple editions with different
> pricing models, there's always a version that suits you!
Unless you don't do Winblows.
Please put Windows dependency clearly in your annou
terface is better than ever and works fine under Wine on
Linux.
Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!
"There is so much new in Database Workbench 5, I don't know where to start",
says Mart
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.7 Pro "
For more information, see http://www.upscene.
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.6 Pro "
For more information, see http://www.upscene.com/g
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.4 Pro "
For more information, see http://www.upscene.
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.3 Pro "
This release fixes a blocking problem after a rece
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.2 Pro "
There's a 15% autumn discount until the end of November!
This release includes enhancements and fixes several bugs as report
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.1 Pro "
This release includes new features and fixes several bugs as reported by the
users.
For more information, see http://www.up
ANN: Database Workbench 4.4.0, free Lite Editions now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.0 Lite"
Today we are making the free Lite Editions ava
Nope, it was locked on a single value for about 36 hours, until we restarted the
engine last night. Now it's running fine, and we're setting up a testbed to
evaluate
MySQL 5.6 and FreeBSD 9 (?) for replacing our current Solaris 10/MySQL 5.1.46
setup.
On 6/28/13 12:44 AM, walter h
Avoid FreeBSD,
Unless they did some real big magic on the scheduler of 9.
Claudio
On Jun 28, 2013 6:12 PM, "Andy Wallace" wrote:
> Nope, it was locked on a single value for about 36 hours, until we
> restarted the
> engine last night. Now it's running fine, and we'
)
>
> And:
>
> mysql> set global timestamp = 0;
> ERROR 1228 (HY000): Variable 'timestamp' is a SESSION variable and can't
> be used with SET GLOBAL
>
> This does indeed persist across sessions. Any command line connection I
> make to the database
>
Ok, I appreciate the Einsteinian and Vonnegut humor... just wanted to say. Still
have the problem though. 8-(
On 6/27/13 9:51 AM, Nick Khamis wrote:
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Well, that begs the question - will restarting the MySQL server instance
tonight fix
the current problem? We do have a plan in place to test and eventually deploy
a more
recent version of MySQL (5.6?), but for now, I have to support 1000's of
customers.
My fingers are crossed.
On 6/27/
Hi,
On 06/27/2013 08:19 PM, Andy Wallace wrote:
Benjamin -
Unfortunately:
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1 row in set (0.00
al timestamp = 0;
ERROR 1228 (HY000): Variable 'timestamp' is a SESSION variable and can't be
used with SET GLOBAL
This does indeed persist across sessions. Any command line connection I make to
the database
shows the "bad" value for NOW(). I also tweaked the application co
---+
1 row in set (0.00 sec)
And:
mysql> set global timestamp = 0;
ERROR 1228 (HY000): Variable 'timestamp' is a SESSION variable and can't be
used with SET GLOBAL
This does indeed persist across sessions. Any command line connection I make
to the database
shows the &quo
Timestamp is a session variable, so it must have been set to something
other than 0 (1372228034 epoch is the date you're showing) in your current
session.
mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)
mysql> select now
AM, Stillman, Benjamin wrote:
>> Timestamp is a session variable, so it must have been set to something
>> other than 0 (1372228034 epoch is the date you're showing) in your
>>current
>> session.
>>
>>
>> mysql> set timestamp = 1372228
n't be
> used with SET GLOBAL
>
> This does indeed persist across sessions. Any command line connection I make
> to the database
> shows the "bad" value for NOW(). I also tweaked the application code to
> include NOW() in an
> existing query, and the value returned t
your current
session.
mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)
mysql> select now(), sysdate();
+-+-----+
| now() | sysdate() |
+-+-+
| 2013-06-26 02:27:14 | 2013-
mysql> select now();
+-----+
| now() |
+-+
| 2013-06-26 02:27:14 |
+-+
While the machine/system date is:
$ date
Thu Jun 27 09:15:25 PDT 2013
I had actually planned to restart the mysql instance on this server last night,
but t
y Wallace" , "mysql list"
>
> Sent: Thursday, 27 June, 2013 1:36:31 AM
> Subject: Re: NOW() is stuck...
>
> Random I-can't-sleep thought: you wouldn't be testint this in a
> single
>
--
Unhappiness is discouraged and will be corrected with kitten pictures.
amp=1372296737;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> select now(); select sleep(5); select now();
+-----+
| now() |
+-+
| 2013-06-26 21:32:17 |
+-+
1 row in set (0.00 sec)
+--+
| s
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately,
and currently
the dang thing is "stuck". For at least the last hour, NOW() is
returning the same
value:
my
0 PM
> To: mysql list
> Subject: NOW() is stuck...
>
> We've been having some issues with one of our MySQL servers lately, and
> currently the dang thing is "stuck". For at least the last hour, NOW() is
> returning the same
> value:
>
> mys
We've been having some issues with one of our MySQL servers lately, and
currently
the dang thing is "stuck". For at least the last hour, NOW() is returning the
same
value:
mysql> select now();
+---------+
| now() |
+-+
| 2
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.0 Pro "
This release includes new features and fixes se
ANN: Database Workbench 4.3.2, free Lite Editions now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.3.2 Lite"
Today we are making the free Lite Editions ava
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.3.2 Pro "
This release fixes several bugs as reported by
ANN: Database Workbench 4.3.1, free Lite Editions now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.3.1 Lite"
Today we are making the free Lite Editions ava
Parallel Universe* is now available as part of Linux OS images at
www.GoGrid.com.
GoGrid.com is a dedicated/cloud server hosing site.
--
*Parallel Universe is a new extension to
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.3.1 Pro "
This release fixes a few issues with MySQL supp
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.3.0 Pro "
For more information, see http://www.upscene.
ANN: Database Workbench 4.2.4, free Lite Editions now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.2.4 Pro "
Today we are making the free Lite Editions ava
e-
> From: Claudio Nanni [mailto:claudio.na...@gmail.com]
> Sent: Sunday, April 29, 2012 6:31 AM
> To: Brown, Charles
> Cc: mysql@lists.mysql.com
> Subject: RE: engine is now innoDB instead of MyISAM.
>
> Charles,
>
> I think going back to MyISAM as default is a good
Well said. Thanks so much.
Sent from my iPhone
On Apr 29, 2012, at 8:02 AM, "Reindl Harald" wrote:
>
>
> Am 29.04.2012 14:50, schrieb Brown:
>> is a complain I received from one of my developer that after following our
>> MySQL
>> Cluster migration
my.cnf on all SQL nodes
.restart the cluster
.reimport your dump , which should drop all Innodb tables
I'm on a bus now I can't check better ;)
Cheers
Claudio
On Apr 29, 2012 2:50 PM, "Brown, Charles" wrote:
> Hello Claudio,
>
> ** **
>
> Thanks for quic
Am 29.04.2012 14:50, schrieb Brown:
> is a complain I received from one of my developer that after following our
> MySQL
> Cluster migration, tables are now defaulting to innodb (how can he tell)
as already said:
the builtin default has changed an you have to configure MyISAM
a
Hello Claudio,
Thanks for quick response and the whitepaper. What precipitated my research and
questions is a complain I received from one of my developer that after
following our MySQL Cluster migration, tables are now defaulting to innodb (
how can he tell) and performance is poor. I&#
t
> statement.
>
> ** **
>
> mysql>
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
> *Sent:* Saturday, April 28, 2012 2:48 PM
> *To:* Brown, Charles
> *Cc:* mysql@lists.mysql.com
&g
; From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Saturday, April 28, 2012 3:01 AM
> To: mysql@lists.mysql.com
> Subject: Re: engine is now innoDB instead of MyISAM.
>
>
>
> Am 28.04.2012 09:00, schrieb Brown:
> > We recently switched from MySQL community to Mysql
Harald [mailto:h.rei...@thelounge.net]
Sent: Saturday, April 28, 2012 3:01 AM
To: mysql@lists.mysql.com
Subject: Re: engine is now innoDB instead of MyISAM.
Am 28.04.2012 09:00, schrieb Brown:
> We recently switched from MySQL community to Mysql clustered using Oracle
> supported MySQl. The p
Am 28.04.2012 09:00, schrieb Brown:
> We recently switched from MySQL community to Mysql clustered using Oracle
> supported MySQl. The problem is, during our testing phase, we observed the
> default engine is now innoDB instead of MyISAM. Any thoughts on that? We're
>
Hello all,
We recently switched from MySQL community to Mysql clustered using Oracle
supported MySQl. The problem is, during our testing phase, we observed the
default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not
getting the performance that we expected
Hello Daevid,
Any plans to add sqlite to your list of supported DBs there?
I develop Android and use LAMP as the server backend. Currently I use
SQLYog
as I have for like 10 years. But I would really like one GUI to work on
both
the android sqlite and the mysql backend since they usually ti
.
> -Original Message-
> From: Martijn Tonies [mailto:m.ton...@upscene.com]
> Sent: Friday, March 23, 2012 2:10 AM
> To: mysql@lists.mysql.com; firebird-to...@yahoogroups.com
> Subject: ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
>
> ANN: Database Workbench
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.2.3 Pro "
For more information, see http://www.upscene.
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.2.1 Pro "
This release includes the FREE Lite ve
ANN: Database Workbench 4.2.0, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular multi-DBMS Windows-based development tool:
" Database Workbench 4.2.0 Pro "
This release includes the FREE Lite versions for
Hi all,
No SQLite support?
http://www.sqlite.org/
Seems curious you wouldn't have this yet, especially given its popularity
on
both embedded systems and Android to say the least.
Indeed, no native SQLite support. Lots of other systems are popular and
not supported.
The reason for this is t
Apparently Winblows-only.
It sure would be nice if people would note platform requirements in their
announcement, rather than forcing people to dig through their websites for such
info.
I guess I should know better; if it doesn't list platform requirements, the
developer hasn't thought beyond
, 2011 6:56 AM
> To: mysql@lists.mysql.com
> Cc: firebird-to...@yahoogroups.com
> Subject: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
>
> ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
>
> Ladies, gentlemen,
>
> Upscene Productions i
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.1.3 Pro "
This release includes the FREE Lite versions for InterBase, Fi
On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman"
wrote:
> > Excluding 'performance_schema' appears to eliminate the error. And it
> > seems does NOT cause a reliability-of-the-backup problem.
>
> Hah, no, backing that up is utterly pointless.
that's a useful/final confirmation. thx.
> No,
- Original Message -
> From: ag...@airpost.net
>
> Excluding 'performance_schema' appears to eliminate the error. And it
> seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless. Never noticed it doing that.
It's basically a virtual schem
On Mon, 06 Jun 2011 12:44 +0200, "Johan De Meersman"
wrote:
>
> I haven't bothered to look for the "bug", but it seems to me to be quite
> reasonable default behaviour to lock the whole lot when you're dumping
> transactional tables - it ensures you dump all tables from the same
> consistent vi
I haven't bothered to look for the "bug", but it seems to me to be quite
reasonable default behaviour to lock the whole lot when you're dumping
transactional tables - it ensures you dump all tables from the same consistent
view.
I would rather take this up with the ZRM people - it should "just
Am 05.06.2011 23:55, schrieb ag...@airpost.net:
> i still have no idea why this is necessary.
take it or not
it is a professional solution which works for
databses with 20 GB every day here with rsync
without interrupt/lock mysqld a second
and it is much faster
> there seems to be a but, prob
i still have no idea why this is necessary.
there seems to be a but, problem, misconfiguration, etc.
wouldn't it make some sense to try to FIX it, rather than setting up a
completely different server?
perhaps someone with an idea of the problem and its solution will be
able to chime in.
--
My
Am 05.06.2011 23:49, schrieb ag...@airpost.net:
>
> On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
> wrote:
>> i would use a replication slave and stop him for consistent backups
>> because dumb locks are not really a good solution independent
>> if this works "normally"
>
> unfortunately, i
On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
wrote:
> i would use a replication slave and stop him for consistent backups
> because dumb locks are not really a good solution independent
> if this works "normally"
unfortunately, i have no idea what that means.
something's apparently broken w
On Sun, 05 Jun 2011 23:30 +0200, "Reindl Harald"
wrote:
> BTW
> WHY is everybody ansering to the list AND the author of the last post?
> this reults in get every message twice :-(
Reply -> sends to ONLY the From == h.rei...@thelounge.net
Reply to all sends to BOTH the From == h.rei...@thelounge.n
BTW
WHY is everybody ansering to the list AND the author of the last post?
this reults in get every message twice :-(
Am 05.06.2011 23:26, schrieb ag...@airpost.net:
> fwiw, others are seeing this. e.g., in addition to the two bugs i'd
> already referenced,
>
> http://www.directadmin.com/forum/s
hm - bad
i would use a replication slave and stop him for consistent backups
because dumb locks are not really a good solution independent
if this works "normally"
Am 05.06.2011 23:26, schrieb ag...@airpost.net:
> fwiw, others are seeing this. e.g., in addition to the two bugs i'd
> already refer
fwiw, others are seeing this. e.g., in addition to the two bugs i'd
already referenced,
http://www.directadmin.com/forum/showthread.php?p=202053
and one
http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
claims a solution
"Add --skip-add-locks to
the grant statements does nobody interest
maybe use phpmyadmin for a clearer display
mysql> select * from mysql.user where user='root' limit 1;
+---+--+---+-+-+-+-+-+---+
hi,
On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald"
wrote:
> have you checked you permissions-table if all privileges are active for root
i've got,
mysql> show grants for 'root'@'localhost';
+--
have you checked you permissions-table if all privileges are active for root
and have you started "ymsql_upgrade" after all updates?
Am 05.06.2011 22:20, schrieb ag...@airpost.net:
> i use ZRM to do backups of my databases.
>
> with v5.1.x, this works fine,
>
>
i use ZRM to do backups of my databases.
with v5.1.x, this works fine,
mysql-zrm-scheduler --now --backup-set manual --backup-level 0
to execute a manual backup.
i recently upgraded from v5.1.x -> v5.5.12,
mysqladmin -V
mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686
now, at e
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.1.2 Pro "
This release includes the FREE Lite versions for InterBase, Fi
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely wrote:
> Shawn Green works for Oracle and has been very helpful, and I am happy to
> eat a little bit of shoe leather!
>
> Thanks Shawn!
>
> Jim
>
Check the archives for Shawn's posts. IMNSHO, they are unparalleled in
clarity and depth and breadth of
Shawn Green works for Oracle and has been very helpful, and I am happy to eat a
little bit of shoe leather!
Thanks Shawn!
Jim
On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote:
> Wow! We paid for MySQL enterprise plus enterprise support back in the good
> old days before ORACLE bought MySQL. I
Wow! We paid for MySQL enterprise plus enterprise support back in the good old
days before ORACLE bought MySQL. I just sacrificed the sacred chicken and
sprinkled the blood around my computer and went to sign up for support at
support.oracle.com. After wading through the crappy Flash interface a
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.1.1 Pro "
This release includes the FREE Lite versions for InterBase, Fi
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.1.0 Pro "
This release includes the FREE Lite versions for InterBase, Firebird
and MySQL.
Version 4 introduced full Unicode support, 4.1.0 adds new
ction environments;
the lessons learned from failure and how to re-engineer your way to a
successful, highly scalable Internet architecture. The conference takes
place at the Tremont Grand Historic Venue on Sept 30 and Oct 1, 2010 in
Baltimore, MD. Register now to enjoy the Early Bird discount and
guarantee
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0.3 Pro "
This release includes the FREE Lite versions for InterBase, Firebird
and MySQL.
Version 4 introduced full Unicode support, 4.0.3 fixes som
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0 Pro"
With this version we're reached a milestone: Database Workbench
is now fully Unicode enabled and offers new tools t
Lincoln feared that the issue of slavery would weaken the northern war effort.
Many men throughout the north would fight to save the Union. They would not
fight to free the slaves.
Although it is often confused with common cold, influenza is a much more severe
disease!
Sorry for crossposting, but I felt this might be of intrerest to both lists.
MyQuery 3.0 is an interactive Windows GUI based query tool for MySQL.
Among the features are>
- Support running scripts from a position, up to a position of just a
single query in the script, allowing you to run up to
mail
> about "Re: Copy 70GB ibdata, etc. and server won't start now", you are not
> currently on my email Guest List. I'll be more likely to see your email and
> future messages if you are on my priority Guest List.
>
> Click here to be put directly on my Guest List
On Tue, Jul 14, 2009 at 2:14 AM, Marcus
Bointon wrote:
> You should take a look at Percona's xtrabackup utility to do this. It takes
> a clean snapshot of an innodb database that can be restored on a target
> machine in a few minutes, though it does crash recovery at backup time which
> can take a
Yep, you dont need to recover the database because:
1) You did a clean shutdown
2) You dont need (as i believe) an integral copy of your database,
because its for a demo, anyway the data is 1 month older, so if you miss
some records
that "probably" will be missing on the log those are not relev
> -Original Message-
> From: Carlos Proal [mailto:carlos.pr...@gmail.com]
> Sent: Tuesday, July 14, 2009 5:13 PM
> >
> > Another thing you can do is simply erase the innodb logs.
> If the dbms
> > really was shutdown properly then the logs are useful,
> > they will be recreated again and
but the dates will change as I muck
with the data on it.
From: Gary Smith [mailto:g...@primeexalia.com] Sent: Tuesday,
July 14, 2009 2:11 PM
To: Johnny Withers; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Copy 70GB ibdata, etc. and server
Gary Smith [mailto:g...@primeexalia.com]
Sent: Tuesday, July 14, 2009 2:11 PM
To: Johnny Withers; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
Johnny,
I'm less worried about the mont
From: Gary Smith [mailto:g...@primeexalia.com]
Sent: Tuesday, July 14, 2009 2:11 PM
To: Johnny Withers; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
_
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:41 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Gary Smith
Subject: Re: Copy 70GB ibdata, etc. and server won't start now
Why do the dates on the log files differ by almost a month betwee
70GB ibdata, etc. and server won't start now
Why do the dates on the log files differ by almost a month between Old and New?
On Tue, Jul 14, 2009 at 2:23 PM, Daevid Vincent
mailto:dae...@daevid.com>> wrote:
> -Original Message-
> From: Gary Smith [mailto:g...@pr
1 - 100 of 475 matches
Mail list logo
