DB Import & Export - Revision history

Tacoball: /* Commands */

2025-04-23T16:57:21Z

Commands

2025-04-23T16:56:24Z

Commands

← Older revision		Revision as of 16:56, 23 April 2025
Line 30:		Line 30:
	sqlite3 my_wiki.sqlite '.dump'		sqlite3 my_wiki.sqlite '.dump'
	sqlite3 my_wiki.sqlite '.dump user'		sqlite3 my_wiki.sqlite '.dump user'
	sqlite3~~.exe~~ -header .\my_wiki.sqlite '.mode insert' 'select * from user;'		sqlite3 -header my_wiki.sqlite '.mode insert' 'select * from user;'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2025-04-23T16:56:04Z

Commands

← Older revision		Revision as of 16:56, 23 April 2025
Line 30:		Line 30:
	sqlite3 my_wiki.sqlite '.dump'		sqlite3 my_wiki.sqlite '.dump'
	sqlite3 my_wiki.sqlite '.dump user'		sqlite3 my_wiki.sqlite '.dump user'
			sqlite3.exe -header .\my_wiki.sqlite '.mode insert' 'select * from user;'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2025-04-23T16:44:38Z

Commands

← Older revision		Revision as of 16:44, 23 April 2025
Line 28:		Line 28:
	\|		\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	sqlite3 '.dump' my_wiki.sqlite		sqlite3 my_wiki.sqlite '.dump'
			sqlite3 my_wiki.sqlite '.dump user'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2025-04-23T16:39:52Z

Commands

2025-04-23T16:38:55Z

Commands

@@ Line 19: / Line 19: @@
 echo 'create database my_wiki;' | mariadb -p
 mariadb -p < data-to-import.sql
 </syntaxhighlight>
 |}

2025-04-23T16:38:14Z

Script to sync db

2025-04-07T07:28:57Z

Commands

← Older revision		Revision as of 07:28, 7 April 2025
Line 10:		Line 10:
	mariadb-dump -p --compatible=postgresql my_wiki		mariadb-dump -p --compatible=postgresql my_wiki
	mariadb-dump -p --no-data --compatible=postgresql my_wiki		mariadb-dump -p --no-data --compatible=postgresql my_wiki
	mariadb-dump -p --no-create_info --compatible=postgresql my_wiki		mariadb-dump -p --no-create_info --compatible=postgresql my_wiki
			mariadb-dump -p --no-create_info --extended-insert=false --compatible=postgresql my_wiki
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2025-04-07T07:26:51Z

Commands

← Older revision		Revision as of 07:26, 7 April 2025
Line 8:		Line 8:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	mariadb-dump -p my_wiki		mariadb-dump -p my_wiki
	mariadb-dump -p --~~no-data~~ my_wiki		mariadb-dump -p --compatible=postgresql my_wiki
	mariadb-dump -p --no-~~create_info~~ my_wiki		mariadb-dump -p --no-data --compatible=postgresql my_wiki
	mariadb-dump -p ~~my_wiki~~ --compatible=postgresql		mariadb-dump -p --no-create_info --compatible=postgresql my_wiki
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2025-04-07T07:21:55Z

Commands

← Older revision		Revision as of 07:21, 7 April 2025
Line 9:		Line 9:
	mariadb-dump -p my_wiki		mariadb-dump -p my_wiki
	mariadb-dump -p --no-data my_wiki		mariadb-dump -p --no-data my_wiki
			mariadb-dump -p --no-create_info my_wiki
	mariadb-dump -p my_wiki --compatible=postgresql		mariadb-dump -p my_wiki --compatible=postgresql
	</syntaxhighlight>		</syntaxhighlight>