Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
Am 27.01.2011 08:53, schrieb Randy Katz: On 1/26/2011 11:37 PM, J. Echter wrote: Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysqlie=utf-8oe=utf-8aq=tclient=firefox-arlz=1R1GGLL_en___US399 I hope that helps, take care Randy Hi, im stuck on starting bacula-director again. There's no error message but bconsle cant connect and netstat -tulpen show no listening director on port 9101. any hints how to solve this? greets juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
Am 27.01.2011 09:57, schrieb J. Echter: Am 27.01.2011 08:53, schrieb Randy Katz: On 1/26/2011 11:37 PM, J. Echter wrote: Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysqlie=utf-8oe=utf-8aq=tclient=firefox-arlz=1R1GGLL_en___US399 I hope that helps, take care Randy Hi, im stuck on starting bacula-director again. There's no error message but bconsle cant connect and netstat -tulpen show no listening director on port 9101. any hints how to solve this? greets juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ok, my bad... i forgot to add new db password in catalog config section. back(ing) up again :) thanks and have a nice day!! juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
On 1/27/2011 12:57 AM, J. Echter wrote: Am 27.01.2011 08:53, schrieb Randy Katz: On 1/26/2011 11:37 PM, J. Echter wrote: Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysqlie=utf-8oe=utf-8aq=tclient=firefox-arlz=1R1GGLL_en___US399 I hope that helps, take care Randy Hi, im stuck on starting bacula-director again. There's no error message but bconsle cant connect and netstat -tulpen show no listening director on port 9101. any hints how to solve this? check what is it /var/bacula/working/log and act accordingly. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
On 01/26/11 11:04, J. Echter wrote: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. That's not a problem. The number of DBs you can run on a single MySQL instance is in practical terms limited only by how much hardware you have under it. I support customers every day who have hundreds of DBs (and sometimes, DBs with thousands of tables) on a single MySQL instance. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid, Migration from SQLite -- MySQL | MySQL already has 1 DB running.
On 1/26/2011 11:37 PM, J. Echter wrote: Am 26.01.2011 17:04, schrieb J. Echter: Hi, im running Ubuntu Lucid Server x64. I'd like to migrate from bacula-sqlite to bacula-mysql, but i have one problem. Im not a MySQL expert and i already have one Database running with MySQL. Can someone advice how to handle my situation without damaging anything? :) I would do the following: 1. dump sqlite db 2. remove sqlite parts of bacula 3. install mysql parts of bacula 4. creating db (there im not sure if can break something if i just use the script from bacula) 5. loading previously dumped tables back to mysql (i dont know how yet) or would postgresql the better choice? cheers juergen -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Hi, im currently trying to feed my sqlite dump back into mysql db... Error i get is: mysql -u root -p bacula.sql Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1 as i said im not so good in this sql stuff :) could anyone point me into the right direction? cheers. juergen. hi, you don't need that line, comment out with a # at the beginning, please if you have more problems feed the next lines before the database/table create statements here and I will look them up. Here are some notes on converting a google search brings more: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql http://www.google.com/search?q=convert+sqlite+to+mysqlie=utf-8oe=utf-8aq=tclient=firefox-arlz=1R1GGLL_en___US399 I hope that helps, take care Randy -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
