[prev in list] [next in list] [prev in thread] [next in thread]
List: amarok-devel
Subject: Re: mysqldump error: 1146: Table 'amarok3.dbplaylist_History' doesn't exist when using LOCK TABLES
From: Alan Ezust <alan.ezust () gmail ! com>
Date: 2013-12-08 4:24:20
Message-ID: CALy5K9r_-RwotYHGvVKhYXbVd=ouqOEiEoA7y9BcaPRt1oZaSg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
oops. you can ignore this message. It's a table I created myself and has
nothing to do with amarok!
sorry.
On Sat, Dec 7, 2013 at 7:32 PM, Alan Ezust <alan.ezust@gmail.com> wrote:
> On Sat, Dec 7, 2013 at 4:49 AM, Edward Toroshchin <edward.hades@gmail.com>wrote:
>
>> Hi Alan,
>>
>> Thanks for helping us fix bugs! We always appreciate the effort.
>>
>
> please don't thank me until I actually do it :-)
>
>
>>
>> Let me try to help you resolve your problems.
>>
>> On Fri, Dec 06, 2013 at 12:51:46PM -0800, Alan Ezust wrote:
>> > Failed to create secure directory (/run/user/1000/pulse): Permission
>> denied
>>
>> I believe your 'kde' user does not have the appropriate permissions. Try
>> running these commands:
>>
>> id kde
>> id <your username>
>>
>> This will show you, to which groups you and the 'kde' user belong. Most
>> probably you will have to add your 'kde' user to one of the groups your
>> user belongs to, most probably 'pulseaudio' or 'audio'.
>>
>
> ok, I changed the permissions. I wasn't sure if there was more to it than
> that.
> Thanks for your help!
>
> > What did I do wrong? How does one copy an existing external amarok mysql
>> > database and use that instead of the original?
>>
>> I think mysql does not recognize the new database if you simply copy the
>> old one.
>>
>> I would personally try to duplicate the database by dumping the old one
>> and recreating the new from the dump. Something along the lines of:
>>
>> # rm -rf /var/lib/mysql/amarok3
>> # mysqladmin create amarok3
>> # mysqldump amarok | mysql -b amarok3
>>
>
> I tried doing a mysqldump of my current amarok database (amarok3) but it
> fails with this message.
>
> [ezust@cerberus] /home/kde/src> mysqldump --debug-info -u amarok -p
> amarok3 > amarok3.sql
> Enter password:
> mysqldump: Got error: 1146: Table 'amarok3.dbplaylist_History' doesn't
> exist when using LOCK TABLES
>
> User time 0.00, System time 0.00
> Maximum resident set size 1868, Integral resident set size 0
> Non-physical pagefaults 642, Physical pagefaults 0, Swaps 0
> Blocks in 0 out 0, Messages in 0 out 0, Signals 0
> Voluntary context switches 17, Involuntary context switches 2
>
> What must I do in order to fix this so I can dump my database?
> Is there some sort of corruption here?
>
>
>
[Attachment #5 (text/html)]
oops. you can ignore this message. It's a table I created myself and has nothing \
to do with amarok!<br>sorry.<br><br><br><div class="gmail_quote">On Sat, Dec 7, 2013 \
at 7:32 PM, Alan Ezust <span dir="ltr"><<a href="mailto:alan.ezust@gmail.com" \
target="_blank">alan.ezust@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div class="gmail_quote">On Sat, Dec 7, 2013 at 4:49 AM, \
Edward Toroshchin <span dir="ltr"><<a href="mailto:edward.hades@gmail.com" \
target="_blank">edward.hades@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Hi Alan,<br>
<br>
Thanks for helping us fix bugs! We always appreciate the \
effort.<br></blockquote><div><br>please don't thank me until I actually do it \
:-)<br> </div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Let me try to help you resolve your problems.<br>
<div><br>
On Fri, Dec 06, 2013 at 12:51:46PM -0800, Alan Ezust wrote:<br>
> Failed to create secure directory (/run/user/1000/pulse): Permission denied<br>
<br>
</div>I believe your 'kde' user does not have the appropriate permissions. \
Try<br> running these commands:<br>
<br>
id kde<br>
id <your username><br>
<br>
This will show you, to which groups you and the 'kde' user belong. Most<br>
probably you will have to add your 'kde' user to one of the groups your<br>
user belongs to, most probably 'pulseaudio' or \
'audio'.<br></blockquote><div><br>ok, I changed the permissions. I wasn't \
sure if there was more to it than that. <br>Thanks for your help!<br><br></div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> > What did I do wrong? How does one copy an existing \
external amarok mysql<br><div> > database and use that instead of the \
original?<br> <br>
</div>I think mysql does not recognize the new database if you simply copy the<br>
old one.<br>
<br>
I would personally try to duplicate the database by dumping the old one<br>
and recreating the new from the dump. Something along the lines of:<br>
<br>
# rm -rf /var/lib/mysql/amarok3<br>
# mysqladmin create amarok3<br>
# mysqldump amarok | mysql -b amarok3<br></blockquote><div><br>I tried doing a \
mysqldump of my current amarok database (amarok3) but it fails with this \
message.<br><br>[ezust@cerberus] /home/kde/src> mysqldump --debug-info -u amarok \
-p amarok3 > amarok3.sql<br>
Enter password: <br>mysqldump: Got error: 1146: Table \
'amarok3.dbplaylist_History' doesn't exist when using LOCK \
TABLES<br><br>User time 0.00, System time 0.00<br>Maximum resident set size 1868, \
Integral resident set size 0<br>
Non-physical pagefaults 642, Physical pagefaults 0, Swaps 0<br>Blocks in 0 out 0, \
Messages in 0 out 0, Signals 0<br>Voluntary context switches 17, Involuntary context \
switches 2<br><br>What must I do in order to fix this so I can dump my database?<br>
Is there some sort of corruption here?<br><br><br></div></div>
</blockquote></div><br>
_______________________________________________
Amarok-devel mailing list
Amarok-devel@kde.org
https://mail.kde.org/mailman/listinfo/amarok-devel
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic