Carl Karsten wrote: > Uwe Grauer wrote: >>> So if you can provide scripts that can setup a test db, including removing >>> a >>> previous one, I will run them. >>> >>> Carl K >> I send the sql-script but if this isn't enough just do a restore of >> the testdb i attached to http://dabodev.com/tracker/0274 >> >> Use the following comandline: >> >> /opt/firebird/bin/gbak -c -v -user SYSDBA -password masterkey >> all_types_fb2.fbk hostname:/yourpath/test_all.fdb >> >> Change your username, password, hostname and filepath according >> to what you are using. > > > sudo apt-get install firebird2-super-server firebird2-utils-super > wget http://dabodev.com/tracker/0274/all_types_fb2.fbk > > ++ gbak -c -v -user SYSDBA -password foo all_types_fb2.fbk > localhost:test_all.fdb
What's your login and your current directory when you run gbak? Provide the right path when you use gbak. The server has to have write access there. gbak is a client tool. The server doesn't know your current working directory. > gbak: opened file all_types_fb2.fbk > gbak: transportable backup -- data in XDR format > gbak: backup file is compressed > gbak: ERROR: Expected backup version 1, 2, or 3. Found 7 > gbak: Exiting before completion due to errors > I tested this my machine and it worked. The md5-sum of the backup file is: d0d73f191dea742e952e4783aefdc1a4 /home/uwe/tmp/testit/all_types_fb2.fbk > > What is the command line way to run the CREATEs you posted to > http://dabodev.com/tracker/0274 ? > Don't know how to do it exactly with isql out of my head. As i told you i haven't used isql for a long time. Read it up for yourself. > Using a backup file to run tests on creates an unknown. one could probably > figure them out, but better to use the CREATE. What do you mean with this? Don't understand whats your problem. Instead of calling isql you call gbak in the script. I told you. You have to know what you are doing here. Running DDL scripts while there are open connections to an already existing database doesn't work in firebird. Read this for a start: http://firebirdsql.org/pdfmanual/Firebird-2.0-QuickStart.pdf Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
