Hi List
I am still struggling with the same issues.
On FreeBSD 11.1, I cannot start the mysql server normally. I have to set
innodb_force_recovery to a value of 6 to get it started. And then it is of
course in read-only mode.
As I understand from previous answers, I should use mysqldump on the
m
Hi Greg,
Have been away from this topic for some time, but it's still an actual
problem.
Still in the category of stupid questions (I read the link at least): No
problem to configure the old server as master if the steps are just to put
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expi
PS
I am using MySQL 5.7
tor. 2. nov. 2017 kl. 20.38 skrev Jon Theil Nielsen :
> Hi Greg,
>
> Thanks again for a thoroug walk-through of my options. I have quite a few
> databases - not extremely many - so if the recovery option should work,
> that's tempting to begin with.
>
> I might have mixed
Hi Greg,
Thanks again for a thoroug walk-through of my options. I have quite a few
databases - not extremely many - so if the recovery option should work,
that's tempting to begin with.
I might have mixed two editions of the /var/db/mysql by accident. So in the
first place, I can remove that dir
Hi Jon,
What version of MySQL are you using (5.7.?) If using the latest MySQL or
MariaDB server, you'll have better performance and features. At 5.7.x,
you've already got full-text searching in innodb tables.
As Jan Steinman pointed out, in general, always dump your data using
mysqldump (as oppo
Hi again,
I renovered a database backup and most content seems okay. When I go to the
last edited page, I get [WfthQ25Pv5U0xFGOqSbrEJI] 2017-11-02 18:17:40:
Fatal undtagelse af typen "MWException".
The error log show something like:
"[Note] Beginning of list of non-natively partitioned tables
"He" (me, "the OP") did that following some - maybe bad - advice found in
another place. But I haven't used mediawiki for a while – so I do have
backups from 2017-08-31 that should be okay.
So what are your suggestions from here? Just copy (not move) it back an try
if i works? Or there might be mor
On 02/11/17 03:51, Jon Theil Nielsen wrote:
> Dear List Users,
>
> I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had
> a crash of my MySQL database. At first, I couldn't start it at all. But
> after deleting ib_logfile* and ibdata*, it came back alive. In the sense
> that
Well, I am far from an expert, if that's what you mean. But I will stop
both the apache and the MySQL server. I guess I can only make the
recommended dumps when the server is running. But after that, I can stop
the servers. Right?
Best regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 21.41 skrev
> From: "Greg Rundlett (freephile)"
>
> Go ahead and stop Apache, and if you haven't already, make a disk copy of
> your mysql data directory for backups.
Minor point, but I don’t know how much the OP knows about MySQL: be sure to
stop mysql, too! Otherwise, a disk copy of the database may not
Thanks a lot for the thorough answer. I will follow your suggestions
tomorrow. And I will report back under any circumstances. I have full root
access, so I guess this could be the way to go.
Thanks again!
Best regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 18.36 skrev Greg Rundlett (freephile
Go ahead and stop Apache, and if you haven't already, make a disk copy of
your mysql data directory for backups. Then start MySQL alone. See if you
get any errors from starting MySQL (find logs at /var/log/mysql/error_log
or similar). Post any errors. If the db server is running, do some checks
o
Sorry to a silly question. But which file should i look for. And do i just
import it into MySQL plain and simple?
Best regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 17.55 skrev John :
> If that is the only issue you can re-create the table (the exact command
> should be in an .sql file) that
Actually, I don't think i stopped the web server. I don't think it is a
memory problem. I have 16 GB in total and this very moment about 0.5 GB
completely free.
Regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 17.55 skrev G Rundlett :
> Did you stop Apache, and start MySQL alone? How much free m
Did you stop Apache, and start MySQL alone? How much free memory is
reported?
On Nov 1, 2017 12:51 PM, "Jon Theil Nielsen" wrote:
> Dear List Users,
>
> I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had
> a crash of my MySQL database. At first, I couldn't start it at all
If that is the only issue you can re-create the table (the exact command
should be in an .sql file) that table doesn't contain critical info
On Wed, Nov 1, 2017 at 12:51 PM Jon Theil Nielsen
wrote:
> Dear List Users,
>
> I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had
Dear List Users,
I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had
a crash of my MySQL database. At first, I couldn't start it at all. But
after deleting ib_logfile* and ibdata*, it came back alive. In the sense
that I can start the server and use many of the databases. Bu
17 matches
Mail list logo
