Gecko [ www.ctm-euromeuble.fr ]

Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.122
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
bacula-sqlite_2_mysqldump.sh	1.03 KB	-rwxr-xr-x	2016-09-21 11:58
dbcheck.sql.gz	2.04 KB	-rw-r--r--	2016-09-21 11:58
postgresql-dump.txt	1.52 KB	-rw-r--r--	2016-09-21 11:58
postgresql-mysql-dump.txt	2.22 KB	-rw-r--r--	2016-09-21 11:58
sqlite2pgsql.gz	2.29 KB	-rw-r--r--	2016-09-21 11:58

Rename

#! /bin/sh
#
# bacula-sqlite_2_mysqldump.sh
#
# Convert a Bacula 1.36.2 Sqlite database to MySQL
# Originally Written by Nic Bellamy <nic@bellamy.co.nz>, Sept/Oct 2003.
# Modified by Silas Bennett <silas.bennett_AT_ge.com>, April 2006 for use with Bacula 1.36.2
#

if [ $1 = '-h' ] || [ $1 = '--help' ] ; then
	echo `basename "$0"`" Usage:"
	echo "	"`basename $0`" takes a ASCII bacula sqlite database dump as an argument,"
	echo "	and writes an SQL dump suitable for use with MySQL to STDOUT."
	echo
	echo "	Example Use:	"`basename $0`" bacula.sqlite.sql > bacula.mysql.sql"
	echo "	Example Use:	"cat bacula.sqlite.sql | `basename $0`" - | mysql -p -u <user> baculadb"
	exit
fi

# If $1 is '-' then cat will read /dev/stdin
cat $1 |
awk '/^INSERT INTO / && $3 != "NextId" && $3 != "Version" { print $0 }' |
sed '/^INSERT INTO [a-zA-Z]* VALUES(/s/(NULL)/(0)/g ; /^INSERT INTO [a-zA-Z]* VALUES(/s/(NULL,/(0,/g ; /^INSERT INTO [a-zA-Z]* VALUES(/s/,NULL,/,0,/g ; /^INSERT INTO [a-zA-Z]* VALUES(/s/,NULL,/,0,/g ; /^INSERT INTO [a-zA-Z]* VALUES(/s/,NULL)/,0)/g'