Database

Dump mySQL databases to .csv

This script converts each table in each mySQL database found into a .csv-file. #!/usr/bin/perl -w #—————————————————————————– # # Name mySQL2csv.pl # # Description : # Convert database tables to csv files # # Limitations: # It doesn’t look very efficient looping over a hash for each row # usage: # mySQL2csv.pl # #—————————————————————————– ##### Standard […]

Dump mySQL databases to .csv Read More »

Perl database functions

A library of database functions, using just DBI ########################################################################### # # Name         dbfunctions.pm # Description : #  Perl library for database functions # ########################################################################### sub dbFunctions { print “Functions in dbfunctions.pmn”; print “====================n”; print “openDBn”; print ”   Open the mysql database.n”; print “doDBI (<SQL>) n”; print ”   Execute <SQL> on database opened on dbhn”; print

Perl database functions Read More »

Oracle

Raw material General ORA-01653: unable to extend table <table> by 128 in tablespace EVENTLOG sqlplus> ALTER TABLESPACE EVENTLOG ADD DATAFILE `ORACLE_HOMEDATABASEEVENT.ORA’ SIZE 30M REUSE; SQLplus Commands end with ; > sqlplus <name>/<password> inloggen in de SQL+ omgeving Noot: host string = nummer van de in te loggen database C:/plus33w.exe <name>/<password>@<Oracleserver> inloggen in de SQL+ omgeving

Oracle Read More »

Ingres

I worked with Ingres on an OpenVMS system. Tables are stored in files. Large tables can be stored in files on several locations. All database meta-data is in the iidbdb database. Table definitions are in .IDX files. Location, storage structure and indexes are in here. isql <dbname> Nice interface to the database. CTRL-L for scrolling

Ingres Read More »

Sybase

For generic SQL see the database mainpage sp_helpdb Show all databases sp_help Show all objects in the current database select name,id,loginame,type from sysobjects where type = ‘U’ Show only the user tables in the currect database bcp <table> out <file> -c -U<user> -P<passwd> -S<engine> Bulk copy out. Copy the data in <table> to <file> as

Sybase Read More »