Bacula-users

[Bacula-users] MySQL and SQLite differences

2009-02-15 18:18:35
Subject: [Bacula-users] MySQL and SQLite differences
From: "Simon Jalandt" <simon.jalandt AT gg-net DOT de>
To: bacula-users AT lists.sourceforge DOT net
Date: Sun, 15 Feb 2009 23:57:43 +0100 (CET)
Hi,

i've migrated my SQLite Database to MySQL with this method:
http://trac.edgewall.org/wiki/SqLiteToMySql

But i've got some problems.

ERROR 1136 (21S01) at line 31762: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31763: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31764: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31765: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31766: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31767: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31768: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31769: Column count doesn't match value count
at row 1
ERROR 1136 (21S01) at line 31770: Column count doesn't match value count
at row 1
ERROR 1146 (42S02) at line 31810: Table 'bacula.NextId' doesn't exist

In the MySQL table Job Media is a value Stripe, in the SQLite is no one.
For what Bacula need this value?
In the SQLite Database is a table NextId, but in MySQL is no one.  For
what Bacula need this table?


Simon




------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] MySQL and SQLite differences, Simon Jalandt <=