There is a good reason that the USE database is not output in those dumps..
it would make the tool very difficult to use for moving data around.
If I might suggest, a simple workaround is to create a shell script along
these lines.. you might to do something a little more sophisticated.
Except that it outputs the USE statement if you have more than one
database, so your theory doesn't hold a lot of water IMHO. Not to mention
it's near the very top of the output so it's pretty easy to trim it off if
you REALLY needed to move the DB (which I presume is not as frequently as
simply
Had a system crash this morning and I can't seem to get mysql back up
and running. This is the error:
InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
2013/11/21 Reindl Harald h.rei...@thelounge.net
Am 21.11.2013 13:51, schrieb Paul Halliday:
Had a system crash this morning and I can't seem to get mysql back up
and running. This is the error:
InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
18 19 20 21 22 23 24
Awesome! Thank you very much Claudio! :)
On Thu, Nov 21, 2013 at 10:40 AM, Claudio Nanni claudio.na...@gmail.comwrote:
Hi Jopoy,
Try this:
SELECT username,sum(acctoutputoctets) AS total_usage FROM radacct WHERE
EXTRACT(YEAR_MONTH FROM acctstarttime) = EXTRACT(YEAR_MONTH FROM
It was indeed corruption :/ what a day. I was able to move everything
over to another partition and have managed to get mysql up and running
again. There was a single file I could not, an .idb (the ,.frm is
there). Is it possible to fix this from ibdata or the logs?
Thanks.
On Thu, Nov 21, 2013
Hi Jopoy,
Try this:
SELECT username,sum(acctoutputoctets) AS total_usage FROM radacct WHERE
EXTRACT(YEAR_MONTH FROM acctstarttime) = EXTRACT(YEAR_MONTH FROM
CURRENT_DATE)and EXTRACT(YEAR_MONTH FROM acctstarttime)
EXTRACT(YEAR_MONTH FROM CURRENT_DATE + INTERVAL 1 MONTH) GROUP BY username
HAVING
Hi! I'm not sure how to phrase this question... anyway, here it is:
I'm trying to show users in DB radius who have exceeded 322100 bytes
(3GB) within the current month. As of writing I can only display total
usage by user with this:
SELECT username,sum(acctoutputoctets) AS total_usage FROM
What is the best way to backup your database. Which are the files that
I need to store on a usb disk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Nick,
On 11/21/2013 10:32 AM, Nick Cameo wrote:
OOoopppsss! I do mean for recovery/continual backup. I will do it
manually, but basically get all the data on a USB disk and be able to
recover/move it (the data) on another machine, the same machine etc..
I hope I did not just open up a
I'm working on some code where I am trying to merge two customer accounts
(we get people signing up under different usernames, emails, or just create
a new account sometimes). I want to test it, and so I need a way to restore
the data in the particular tables. Taking a dump of all the DBs and
Am 21.11.2013 18:59, schrieb Paul Halliday:
It was indeed corruption :/ what a day. I was able to move everything
over to another partition and have managed to get mysql up and running
again. There was a single file I could not, an .idb (the ,.frm is
there). Is it possible to fix this from
OOoopppsss! I do mean for recovery/continual backup. I will do it
manually, but basically get all the data on a USB disk and be able to
recover/move it (the data) on another machine, the same machine etc..
I hope I did not just open up a can of worms. We just went live and
this post gave me a
Am 21.11.2013 13:51, schrieb Paul Halliday:
Had a system crash this morning and I can't seem to get mysql back up
and running. This is the error:
InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
41
14 matches
Mail list logo
