[Q] Skip sql update

fiction · July 29, 2019

Hi, recently i restore a sql DB.

But in the map-server, appear the following:

[SQL]: - detected 57 new SQL updates
[SQL]: -- 'sql-files/upgrades/2013-02-14--16-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-02-15--18-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-27--18-35.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--02-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'
[SQL]: -- 'sql-files/upgrades/2013-12-24--00-15.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-04--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-06--17-22.sql'
[SQL]: -- 'sql-files/upgrades/2014-02-19--17-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-03-25--23-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-07--22-04.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-26--10-00.sql'
[SQL]: -- 'sql-files/upgrades/2014-05-17--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2014-09-01--16-53.sql'
[SQL]: -- 'sql-files/upgrades/2014-11-03--00-45.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-02--18-14.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-08--13-08.sql'
[SQL]: -- 'sql-files/upgrades/2015-08-27--20-42.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-16--12-57.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-17--15-58.sql'
[SQL]: -- 'sql-files/upgrades/2016-03-10--22-18.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-42.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-51.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-03--20-27.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-26--10-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-02--11-40.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-05--08-09.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-15--14-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-04.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-05.sql'
[SQL]: -- 'sql-files/upgrades/2017-11-04--10-39.sql'
[SQL]: -- 'sql-files/upgrades/2018-02-26--15-57.sql'
[SQL]: -- 'sql-files/upgrades/2018-03-10--04-06.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--00-10.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--17-16.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-05--12-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-07-24--03-23.sql'
[SQL]: -- 'sql-files/upgrades/2018-09-01--05-22.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-14--01-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-29--07-51.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-08--21-52.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-25--02-12.sql'
[SQL]: -- 'sql-files/upgrades/2019-05-09--18-07.sql'
[SQL]: To manually skip, type: 'sql update skip <file name>'

This command is outdated:

: To manually skip, type: 'sql update skip <file name>'

Exist an alternative to clean this messages?

Edited July 29, 2019 by fiction

KirieZ · July 30, 2019

If you are sure that you have all the updates, I think you can run the queries that insert entries in the sql_updates table: https://github.com/HerculesWS/Hercules/blob/stable/sql-files/main.sql#L876

cookie-rae · July 30, 2019

7 hours ago, fiction said:

Hi, recently i restore a sql DB.

But in the map-server, appear the following:

Hide contents

: - detected 57 new SQL updates
[SQL]: -- 'sql-files/upgrades/2013-02-14--16-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-02-15--18-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-27--18-35.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--02-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'
[SQL]: -- 'sql-files/upgrades/2013-12-24--00-15.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-04--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-06--17-22.sql'
[SQL]: -- 'sql-files/upgrades/2014-02-19--17-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-03-25--23-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-07--22-04.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-26--10-00.sql'
[SQL]: -- 'sql-files/upgrades/2014-05-17--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2014-09-01--16-53.sql'
[SQL]: -- 'sql-files/upgrades/2014-11-03--00-45.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-02--18-14.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-08--13-08.sql'
[SQL]: -- 'sql-files/upgrades/2015-08-27--20-42.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-16--12-57.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-17--15-58.sql'
[SQL]: -- 'sql-files/upgrades/2016-03-10--22-18.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-42.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-51.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-03--20-27.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-26--10-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-02--11-40.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-05--08-09.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-15--14-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-04.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-05.sql'
[SQL]: -- 'sql-files/upgrades/2017-11-04--10-39.sql'
[SQL]: -- 'sql-files/upgrades/2018-02-26--15-57.sql'
[SQL]: -- 'sql-files/upgrades/2018-03-10--04-06.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--00-10.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--17-16.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-05--12-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-07-24--03-23.sql'
[SQL]: -- 'sql-files/upgrades/2018-09-01--05-22.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-14--01-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-29--07-51.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-08--21-52.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-25--02-12.sql'
[SQL]: -- 'sql-files/upgrades/2019-05-09--18-07.sql'
[SQL]: To manually skip, type: 'sql update skip <file name>'



[SQL]: - detected 57 new SQL updates
[SQL]: -- 'sql-files/upgrades/2013-02-14--16-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-02-15--18-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'
[SQL]: -- 'sql-files/upgrades/2013-03-27--18-35.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'
[SQL]: -- 'sql-files/upgrades/2013-04-16--02-15.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'
[SQL]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'
[SQL]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'
[SQL]: -- 'sql-files/upgrades/2013-12-24--00-15.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-04--16-47.sql'
[SQL]: -- 'sql-files/upgrades/2014-01-06--17-22.sql'
[SQL]: -- 'sql-files/upgrades/2014-02-19--17-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-03-25--23-57.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-07--22-04.sql'
[SQL]: -- 'sql-files/upgrades/2014-04-26--10-00.sql'
[SQL]: -- 'sql-files/upgrades/2014-05-17--00-06.sql'
[SQL]: -- 'sql-files/upgrades/2014-09-01--16-53.sql'
[SQL]: -- 'sql-files/upgrades/2014-11-03--00-45.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-02--18-14.sql'
[SQL]: -- 'sql-files/upgrades/2015-07-08--13-08.sql'
[SQL]: -- 'sql-files/upgrades/2015-08-27--20-42.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-16--12-57.sql'
[SQL]: -- 'sql-files/upgrades/2015-12-17--15-58.sql'
[SQL]: -- 'sql-files/upgrades/2016-03-10--22-18.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-42.sql'
[SQL]: -- 'sql-files/upgrades/2016-07-08--02-51.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-03--20-27.sql'
[SQL]: -- 'sql-files/upgrades/2016-10-26--10-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-02--11-40.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-05--08-09.sql'
[SQL]: -- 'sql-files/upgrades/2017-03-15--14-29.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-04.sql'
[SQL]: -- 'sql-files/upgrades/2017-06-04--15-05.sql'
[SQL]: -- 'sql-files/upgrades/2017-11-04--10-39.sql'
[SQL]: -- 'sql-files/upgrades/2018-02-26--15-57.sql'
[SQL]: -- 'sql-files/upgrades/2018-03-10--04-06.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--00-10.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-03--17-16.sql'
[SQL]: -- 'sql-files/upgrades/2018-06-05--12-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-07-24--03-23.sql'
[SQL]: -- 'sql-files/upgrades/2018-09-01--05-22.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-14--01-02.sql'
[SQL]: -- 'sql-files/upgrades/2018-12-29--07-51.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-08--21-52.sql'
[SQL]: -- 'sql-files/upgrades/2019-04-25--02-12.sql'
[SQL]: -- 'sql-files/upgrades/2019-05-09--18-07.sql'
[SQL]: To manually skip, type: 'sql update skip <file name>'

This command is outdated:

: To manually skip, type: 'sql update skip <file name>'


: To manually skip, type: 'sql update skip <file name>'

Exist an alternative to clean this messages?

you dont want to show this error file? you manually update the whole file like this mysql -u root -p ragnarok < sample.sql -f

the -f is to force to in in sql.

fiction · July 30, 2019

Oh.. for some reason my doubt appear in the spoiler box. Anyways, that i trying to do is to clean this message, because my sql database is already up to date.

bWolfie · August 1, 2019

You shouldn't skip sql updates. Server will break in some cases if you do.

Sign In

[Q] Skip sql update

Question

fiction 14

Share this post

Link to post

Share on other sites

4 answers to this question

Recommended Posts

KirieZ 78

Share this post

Link to post

Share on other sites

cookie-rae 6

Share this post

Link to post

Share on other sites

fiction 14

Share this post

Link to post

Share on other sites

bWolfie 138

Share this post

Link to post

Share on other sites

Join the conversation

Recently Browsing 0 members

Chat

GitHub

Community

Documentation

Important Information