Database Management
To create and manage MySQL databases only over the command line can be quite challenging. You may know to the browser-based tool “phpMyAdmin”, but this tool has some limitations (e.g. no visual data base design)
To overcome this problem, you can download the MySQL Workbench from https://www.mysql.com/de/products/workbench
Install the program, start it and add your database credentials using the plus right to “MySQL Connections”. Caution, maybe not every database can be accessed directly throw the internet, many databases listen only to localhost for security reasons. If this is the case, use Standard TCP/IP over SSH to let MySQL Workbench to create an SSH tunnel for you.
Now you can use the MySQL Workbench to create and manage your databases.
Taggings:
How to manage MySQL databases with an easy to use GUI?
Taggings:
PostgreSQL Database Backup Takes Too Long
While giving a training course on PostgreSQL, the problem arose that a pg_dump of their database would take too long.
The database contains more or less nothing else than BLOBs (PDF files). Currently only 500MB, but there are 45GB of archived files (from the last 10 years or so) and new ones will be added on a daily basis. So at least 50GB (older files could be removed) will be stored in the database.
Doing a test dump with pg_dump takes approximately 3 minutes for 500MB (on the given system) - which means 50GB will take somewhere around 5 hours. That is definitely too long, as the backup will need to run every night and additional file system backups (with IBM Tivoli) need to be performed as well.
Oracle and C-Compiling Error
For security reasons a server offering webservices should be installed new: It is used to run CGI-Webapplications manipulating data in an Oracle 8.1.8. database via webformulas. I first installed Solaris and then Oracle 8.1.8 and the webserver. Both are running without errors. In the next step I used the compiled Files from the backup copy: The webservices are running. To modify the applications a new compilation is necessary. I dir not panipulate *.c files. I just tried to compile it. CC or GCC did not work. I got the information, that make-files are used so I tried gmake with the following mistake. How can I make it run?
servernumberone[62]% gmake unregister.c
gcc -xO2 -Xa -xstrconst -xF -mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP
-I/oracle/u1/app/oracle/product/8.1.7/precomp/hdrs -I/oracle/u1/app/oracle/product/8.1.7/precomp/public
-I/oracle/u1/app/oracle/product/8.1.7/precomp/include -I/oracle/u1/app/oracle/product/8.1.7/oracore/include
-I/oracle/u1/app/oracle/product/8.1.7/oracore/public -I/oracle/u1/app/oracle/product/8.1.7/oracore/port/include
-I/oracle/u1/app/oracle/product/8.1.7/nlsrtl/include -I/oracle/u1/app/oracle/product/8.1.7/slax/include -I. -DSLMXMX_ENABLE -DSLTS_ENABLE
-D_SVID_GETTOD -c -o unregister.o unregister.c
gcc: cannot specify -o with -c or -S and multiple compilations
gmake: *** [anmeldung.o] Error 1
servernumberone[63]%
