How to repair the database files - Revision history

Myonlake at 22:22, 24 December 2022

2022-12-24T22:22:39Z

← Older revision		Revision as of 22:22, 24 December 2022
Line 39:		Line 39:
	===Only way===		===Only way===
	(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)		(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)
	*Download sqlite-~~shell~~-linux from [https://www.sqlite.org/2022/sqlite-tools-linux-x86-3400000.zip here]. If that link fails, the main download page is [https://www.sqlite.org/download.html here].		*Download sqlite-tools-linux-x86 from [https://www.sqlite.org/2022/sqlite-tools-linux-x86-3400000.zip here]. If that link fails, the main download page is [https://www.sqlite.org/download.html here].
	*Unzip and put sqlite3 into ''server/mods/deathmatch/''		*Unzip and put sqlite3 into ''server/mods/deathmatch/''
	*To repair internal.db:		*To repair internal.db:

Myonlake at 22:22, 24 December 2022

2022-12-24T22:22:03Z

← Older revision		Revision as of 22:22, 24 December 2022
Line 14:		Line 14:

	===Easy way===		===Easy way===
	*Download [~~http~~://~~updatesa~~.~~mtasa~~.com~~/sa~~/files~~/sqlite~~/mtasa-db-repair-win.zip this]		*Download [https://mirror-cdn.multitheftauto.com/files/mtasa-db-repair-win.zip this]
	*Unzip and put the files into ''server/mods/deathmatch/''		*Unzip and put the files into ''server/mods/deathmatch/''
	*Double click on ''sqlite_repair_internal_db.bat'' to repair internal.db		*Double click on ''sqlite_repair_internal_db.bat'' to repair internal.db
Line 21:		Line 21:
	===Hard way===		===Hard way===

	*Download sqlite-~~shell~~-win32 from [~~http~~://www.sqlite.org/sqlite-~~shell~~-win32-x86-~~3070700~~.zip here]. If that link fails, the main download page is [~~http~~://www.sqlite.org/download.html here].		*Download sqlite-tools-win32 from [https://www.sqlite.org/2022/sqlite-tools-win32-x86-3400000.zip here]. If that link fails, the main download page is [https://www.sqlite.org/download.html here].
	*Unzip and put sqlite3.exe into ''server/mods/deathmatch/''		*Unzip and put sqlite3.exe into ''server/mods/deathmatch/''
	*Open command prompt the change directory to ''server/mods/deathmatch/''		*Open command prompt the change directory to ''server/mods/deathmatch/''
Line 39:		Line 39:
	===Only way===		===Only way===
	(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)		(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)
	*Download sqlite-shell-linux from [~~http~~://www.sqlite.org/sqlite-~~shell~~-linux-x86-~~3070700~~.zip here]. If that link fails, the main download page is [~~http~~://www.sqlite.org/download.html here].		*Download sqlite-shell-linux from [https://www.sqlite.org/2022/sqlite-tools-linux-x86-3400000.zip here]. If that link fails, the main download page is [https://www.sqlite.org/download.html here].
	*Unzip and put sqlite3 into ''server/mods/deathmatch/''		*Unzip and put sqlite3 into ''server/mods/deathmatch/''
	*To repair internal.db:		*To repair internal.db:

Alan.Alexander at 00:23, 17 September 2012

2012-09-17T00:23:27Z

← Older revision		Revision as of 00:23, 17 September 2012
Line 45:		Line 45:
	**Do this command: '''./sqlite3 internal_original.db .dump \| ./sqlite3 internal_repaired.db'''		**Do this command: '''./sqlite3 internal_original.db .dump \| ./sqlite3 internal_repaired.db'''
	**Copy '''internal_repaired.db''' to '''internal.db'''		**Copy '''internal_repaired.db''' to '''internal.db'''
			<section name="Commands" class="server" show="false">
			<syntaxhighlight lang="lua">
			cp internal.db internal_original.db
			./sqlite3 internal_original.db .dump \| ./sqlite3 internal_repaired.db
			cp internal_repaired.db internal.db
			</syntaxhighlight>
			</section>

	*To repair registry.db:		*To repair registry.db:
Line 50:		Line 57:
	**Do this command: '''./sqlite3 registry_original.db .dump \| ./sqlite3 registry_repaired.db'''		**Do this command: '''./sqlite3 registry_original.db .dump \| ./sqlite3 registry_repaired.db'''
	**Copy '''registry_repaired.db''' to '''registry.db'''		**Copy '''registry_repaired.db''' to '''registry.db'''
			<section name="Commands" class="server" show="false">
			<syntaxhighlight lang="lua">
			cp registry.db registry_original.db
			./sqlite3 registry_original.db .dump \| ./sqlite3 registry_repaired.db
			cp registry_repaired.db registry.db
			</syntaxhighlight>
			</section>

	[[Category: Support]]		[[Category: Support]]
	[[ru:How to repair the database files]]		[[ru:How to repair the database files]]

Winky-: Added to category support

2012-06-27T14:17:41Z

Added to category support

← Older revision		Revision as of 14:17, 27 June 2012
Line 51:		Line 51:
	**Copy '''registry_repaired.db''' to '''registry.db'''		**Copy '''registry_repaired.db''' to '''registry.db'''

			[[Category: Support]]
	[[ru:How to repair the database files]]		[[ru:How to repair the database files]]

Qaisjp: /* Linux server */

2012-06-27T12:52:27Z

Linux server

← Older revision		Revision as of 12:52, 27 June 2012
Line 38:		Line 38:

	===Only way===		===Only way===
			(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)
	*Download sqlite-shell-linux from [http://www.sqlite.org/sqlite-shell-linux-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].		*Download sqlite-shell-linux from [http://www.sqlite.org/sqlite-shell-linux-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].
	*Unzip and put sqlite3 into ''server/mods/deathmatch/''		*Unzip and put sqlite3 into ''server/mods/deathmatch/''

Kzman: Formatted

2012-05-24T02:44:11Z

Formatted

← Older revision		Revision as of 02:44, 24 May 2012
Line 1:		Line 1:
	=You might be OK=		==You might be OK==
	There might be nothing to worry about. Check these points:		There might be nothing to worry about. Check these points:
	* Did you come to this page because of a message you saw in the server console or logs?		* Did you come to this page because of a message you saw in the server console or logs?
Line 6:		Line 6:
	* If so, then everything is OK. You don't have to do anything written below and you can safely ignore the error message.		* If so, then everything is OK. You don't have to do anything written below and you can safely ignore the error message.

	=Warnings=		==Warnings==
	'''Backup all files before attempting a repair!'''		'''Backup all files before attempting a repair!'''
	<br>		<br>
	'''Shutdown the server before attempting a repair!'''		'''Shutdown the server before attempting a repair!'''

	=Windows server=		==Windows server==

	==Easy way==		===Easy way===
	*Download [http://updatesa.mtasa.com/sa/files/sqlite/mtasa-db-repair-win.zip this]		*Download [http://updatesa.mtasa.com/sa/files/sqlite/mtasa-db-repair-win.zip this]
	*Unzip and put the files into ''server/mods/deathmatch/''		*Unzip and put the files into ''server/mods/deathmatch/''
Line 19:		Line 19:
	*Double click on ''sqlite_repair_registry_db.bat'' to repair registry.db		*Double click on ''sqlite_repair_registry_db.bat'' to repair registry.db

	==Hard way==		===Hard way===

	*Download sqlite-shell-win32 from [http://www.sqlite.org/sqlite-shell-win32-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].		*Download sqlite-shell-win32 from [http://www.sqlite.org/sqlite-shell-win32-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].
Line 35:		Line 35:


	=Linux server=		==Linux server==

	==Only way==		===Only way===

	*Download sqlite-shell-linux from [http://www.sqlite.org/sqlite-shell-linux-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].		*Download sqlite-shell-linux from [http://www.sqlite.org/sqlite-shell-linux-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].

Vincent at 13:53, 14 May 2012

2012-05-14T13:53:52Z

← Older revision		Revision as of 13:53, 14 May 2012
Line 50:		Line 50:
	**Do this command: '''./sqlite3 registry_original.db .dump \| ./sqlite3 registry_repaired.db'''		**Do this command: '''./sqlite3 registry_original.db .dump \| ./sqlite3 registry_repaired.db'''
	**Copy '''registry_repaired.db''' to '''registry.db'''		**Copy '''registry_repaired.db''' to '''registry.db'''

			[[ru:How to repair the database files]]

Ccw at 08:34, 29 January 2012

2012-01-29T08:34:20Z

← Older revision		Revision as of 08:34, 29 January 2012
Line 1:		Line 1:
			=You might be OK=
			There might be nothing to worry about. Check these points:
			* Did you come to this page because of a message you saw in the server console or logs?
			* Is the following text at the start of the error message block?
			ERROR: near "3": syntax error
			* If so, then everything is OK. You don't have to do anything written below and you can safely ignore the error message.

	=Warnings=		=Warnings=
	'''Backup all files before attempting a repair!'''		'''Backup all files before attempting a repair!'''

Ccw: Created page with "=Warnings= '''Backup all files before attempting a repair!'''
'''Shutdown the server before attempting a repair!''' =Windows server= ==Easy way== *Download [http://updates..."

2011-06-25T22:05:25Z

Created page with "=Warnings= '''Backup all files before attempting a repair!''' <br> '''Shutdown the server before attempting a repair!''' =Windows server= ==Easy way== *Download [http://updates..."

New page

=Warnings=
'''Backup all files before attempting a repair!'''
<br>
'''Shutdown the server before attempting a repair!'''

=Windows server=

==Easy way==
*Download [http://updatesa.mtasa.com/sa/files/sqlite/mtasa-db-repair-win.zip this]
*Unzip and put the files into ''server/mods/deathmatch/''
*Double click on ''sqlite_repair_internal_db.bat'' to repair internal.db
*Double click on ''sqlite_repair_registry_db.bat'' to repair registry.db

==Hard way==

*Download sqlite-shell-win32 from [http://www.sqlite.org/sqlite-shell-win32-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].
*Unzip and put sqlite3.exe into ''server/mods/deathmatch/''
*Open command prompt the change directory to ''server/mods/deathmatch/''
*To repair internal.db:
**Copy '''internal.db''' to '''internal_original.db'''
**Do this command: '''sqlite3.exe internal_original.db .dump | sqlite3.exe internal_repaired.db'''
**Copy '''internal_repaired.db''' to '''internal.db'''

*To repair registry.db:
**Copy '''registry.db''' to '''registry_original.db'''
**Do this command: '''sqlite3.exe registry_original.db .dump | sqlite3.exe registry_repaired.db'''
**Copy '''registry_repaired.db''' to '''registry.db'''

=Linux server=

==Only way==

*Download sqlite-shell-linux from [http://www.sqlite.org/sqlite-shell-linux-x86-3070700.zip here]. If that link fails, the main download page is [http://www.sqlite.org/download.html here].
*Unzip and put sqlite3 into ''server/mods/deathmatch/''
*To repair internal.db:
**Copy '''internal.db''' to '''internal_original.db'''
**Do this command: '''./sqlite3 internal_original.db .dump | ./sqlite3 internal_repaired.db'''
**Copy '''internal_repaired.db''' to '''internal.db'''

*To repair registry.db:
**Copy '''registry.db''' to '''registry_original.db'''
**Do this command: '''./sqlite3 registry_original.db .dump | ./sqlite3 registry_repaired.db'''
**Copy '''registry_repaired.db''' to '''registry.db'''

How to repair the database files - Revision history

Myonlake at 22:22, 24 December 2022

Myonlake at 22:22, 24 December 2022

Alan.Alexander at 00:23, 17 September 2012

Winky-: Added to category support

Qaisjp: /* Linux server */

Kzman: Formatted

Vincent at 13:53, 14 May 2012

Ccw at 08:34, 29 January 2012

Ccw: Created page with "=Warnings= '''Backup all files before attempting a repair!''' '''Shutdown the server before attempting a repair!''' =Windows server= ==Easy way== *Download [http://updates..."

Ccw: Created page with "=Warnings= '''Backup all files before attempting a repair!'''
'''Shutdown the server before attempting a repair!''' =Windows server= ==Easy way== *Download [http://updates..."