Date: 08/01/07 (Java Web)    Keywords: database, sql, java

HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database. It can also create a read-only database out of any CSV files. HSQLDB is the database used with OpenOffice. The steps to quickly and safely backup HSQLDB Database are: Run the SQL command [...]

Source: http://blog.taragana.com/index.php/archive/how-to-quickly-backup-hsqldb-database/

Date: 08/01/07 (Web Development)    Keywords: php, mysql, browser, sql, apache

ok, this is getting posted a few places because I'm head/desk-ing all over the place on it.

Have Intranet, Intranet is based around an OS X Mac running Apache/PHP/MySQL. Was working fine, OS X server (just regular OS X but the machine is designed to work as a server) was at someone's house. Worked fine with the IP it had there and everything pointing to it, which was actually the IP of the router it was connected to I believe. This was the ServerName address in httpd.conf . Server moved to small office, BOOM.

Updated the ServerName value in httpd.conf to the proper IP for the machine, however if you try and go to that IP (how the intranet works there, via the browsers connecting to that ip then going where they need to from the index page there) it gives a "Forbidden" error (don't think it's even a 403) and says that you don't have permission to connect to the OLD IP address. I don't understand this, we even disconnected it from the internet to see if it was even actually trying to connect to that IP and no, same error. Anything else and it says it cannot be reached when the uplink is disconnected, so definitely a problem on the server somehow. On top of that, localhost and 127.0.0.1 will work, the machine will reach out to the internet and can be mounted in internet explorer with the \\servername\path\etc., however this won't let us access the PHP processor to display the pages, just the files themselves.

Is there anywhere else that a problem like this could lurk? Just uninstall Apache and re-install? I've never removed Apache from a machine or done a make of apache or anything else on a mac so I'm not exactly sure how to if that would even help. Really don't understand what's going on and I need to get this up ASAP. :( Any help please? Will repay in kind somehow, not monetarily but somehow (work, knowledge, something).

Thanks!

Cross posted all over sort of.

Source: http://community.livejournal.com/webdev/425477.html

Date: 08/01/07 (PHP Community)    Keywords: php, mysql, browser, sql, apache

ok, this is getting posted a few places because I'm head/desk-ing all over the place on it.

Have Intranet, Intranet is based around an OS X Mac running Apache/PHP/MySQL. Was working fine, OS X server (just regular OS X but the machine is designed to work as a server) was at someone's house. Worked fine with the IP it had there and everything pointing to it, which was actually the IP of the router it was connected to I believe. This was the ServerName address in httpd.conf . Server moved to small office, BOOM.

Updated the ServerName value in httpd.conf to the proper IP for the machine, however if you try and go to that IP (how the intranet works there, via the browsers connecting to that ip then going where they need to from the index page there) it gives a "Forbidden" error (don't think it's even a 403) and says that you don't have permission to connect to the OLD IP address. I don't understand this, we even disconnected it from the internet to see if it was even actually trying to connect to that IP and no, same error. Anything else and it says it cannot be reached when the uplink is disconnected, so definitely a problem on the server somehow. On top of that, localhost and 127.0.0.1 will work, the machine will reach out to the internet and can be mounted in internet explorer with the \\servername\path\etc., however this won't let us access the PHP processor to display the pages, just the files themselves.

Is there anywhere else that a problem like this could lurk? Just uninstall Apache and re-install? I've never removed Apache from a machine or done a make of apache or anything else on a mac so I'm not exactly sure how to if that would even help. Really don't understand what's going on and I need to get this up ASAP. :( Any help please? Will repay in kind somehow, not monetarily but somehow (work, knowledge, something).

Thanks!

Cross posted all over sort of.

Source: http://community.livejournal.com/php/578944.html

Date: 08/02/07 (MySQL Communtiy)    Keywords: mysql, database, sql, microsoft, google

This one's got me at the end of my rope, and none of the answers I'm finding searching in the many places I've searched have given me any help, so I'll ask you guys.

First off: I am brand new (as in a couple of weeks) to MySQL, after moving to Ubuntu (Feisty) at home. (Goodbye Microsoft.) I'm a SQL Server DBA/DWA/Database Developer/jack-of-all-trades at work, so I do have some DB experience, just not with MySQL.

Anyway, I've created a schema and the tables in it. Now I'm trying to relate those tables. All use the InnoDB engine.* The guinea pigs I'm using are the BOOK and AUTHOR tables, and I'm trying to relate the ID field in AUTHOR to the AUTHORID field in BOOK. (And, yes, I've tried changing the name of ID to AUTHORID with no success.) Both are type INT. ID/AUTHORID is an ident-seeded primary key. AUTHORID in the BOOK table is a foreign key. Or it's supposed to be, but when I try to relate them, I get the infamous error 1005 (can't create table './directory/filename.frm'). I've found extensive discussion on this at ubuntuforums, forums.mysql.com, and a number of blogs, and have checked everything I've found, modified everything I can, and I still get the error. Basically, if you search on "error 1005" on google and check the first 150 non-repeating pages that come up, I've tried/checked everything that comes up to no avail. I'm at a loss for what do do next, and hoping someone has some ideas.

Also, I tried running a MySQL instance on my XP machine at work, created the exact same tables the exact same way, and tried the relation. It worked on the first try without a hitch.

If anyone's got some help, I'd be truly grateful. Thanks. If more info is needed, I'll report back tonight when I'm actually sitting at my Ubuntu machine.

* As a side note, for philosophical purposes only: why are there so many available engines that don't support foreign keys? Do that many people create non-relational databases? Just wondering.

Source: http://community.livejournal.com/mysql/117098.html

Date: 08/02/07 (IT Professionals)    Keywords: sql, linux

«Работай там, где ты можешь создать что-то действительно важное...»

Source: http://community.livejournal.com/itprofessionals/62196.html

Date: 08/12/07 (Open Source)    Keywords: mysql, sql

What is happening is that mySQL FOSS and mySQL open source are now different products.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/143406695/

Date: 08/13/07 (Java Web)    Keywords: sql

In short in HSQLDB cached table sucks in terms of performance. To elaborate I was running a program which takes around 9 hours running on two medium sized cached tables (bigger one 163 MB). I changed the tables to memory tables (default) and it now takes less than 10 minutes. Let’s see how we can [...]

Source: http://blog.taragana.com/index.php/archive/hsqldb-cached-table-versus-memory-table-performance-conversion/

Date: 08/13/07 (WebDesign)    Keywords: mysql, html, database, sql

Is it possible to create a search function without using database?

If I design a site that's purely HTML, can I add a search function? There will many products on the page, and I want the user have the ability to search item name and list the page.

I wish I know MySQL and write backend. This is hard for me, probably will rely on frontpage extension.

Source: http://community.livejournal.com/webdesign/1294641.html

Date: 08/14/07 (Open Source)    Keywords: mysql, sql, postgresql

Are mySQL, PostgreSQL and Ingres really better than Oracle, because they are continuing to gain share. Or are their gains down, at least in part, to the fact that they're open and free?

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/144042624/

Date: 08/14/07 (Web Development)    Keywords: php, database, sql, web

Hello, I was wondering if there was anyone out there who could help me find a GUI for SQLite that is free?

I just want it to set up the database, My plan is to enter everything into the db with php though a web form. (is that possible?)

thank you kindly (ahead of time) for any help.

Source: http://community.livejournal.com/webdev/429074.html

Date: 08/14/07 (WebDesign)    Keywords: php, database, sql, web

Hello, I was wondering if there was anyone out there who could help me find a GUI for SQLite that is free?

I just want it to set up the database, My plan is to enter everything into the db with php though a web form. (is that possible?)

thank you kindly (ahead of time) for any help.

Source: http://community.livejournal.com/webdesign/1295370.html

Date: 08/15/07 (Web Development)    Keywords: database, sql, web

I'm working on a commercial website, and I've employed a small company to build the site as it requires a database and I don't know about making such things. They are building it in MSSQL.

A few days ago we saw the first rough version of the site, which was showing progress. However we didn't like the menu being placed down the side of the page, and want it moved to run across the top. Unfortunately, they have replied saying they can't move the menu now, it is too late, the menu at the side has already been coded in to the database.

Aside from the fact that I am very angry about this decision of theirs to build in a side menu without confirming that was what we wanted, what I'd like to know is, how 'built in' to the database structure is the page structure? I had no idea it was integrated at all. Is it really a huge job to change the layout from a side menu to a top menu, or are they just complaining because they can't be bothered?

Don't tell me I should have employed a different company because it's too late for that now and I'm already thinking it :o/

Source: http://community.livejournal.com/webdev/429740.html

Date: 08/20/07 (WebDesign)    Keywords: php, mysql, database, sql

I have a mySQL database, and one of the tables is used as the backend for a ratings system in which people can rate images on a scale of 1-5. In it, I have columns for the following data: id (a primary key field), userid (their phpBB userid), total votes cast, and then a column for every item in the rating system, just as a y/n toggle to check whether or not a person has rated that item. Actual scores are stored elsewhere.

My problem is fairly simple: I need to clear some of the ratings, because the images are going to change. How can I count up the total number of 'y' in a row in my database in order to update the total votes to reflect that some votes have been reset? Each row represents one user's votes, so it might say that user 1 has voted on images 1, 3 and 5, but not 2 and 4. I want to be able to find out that user 1 has voted 3 times. mysql_num_rows, of course, just returns 1, and I think mysql_num_cols/columns doesn't exist. Right now, the system simply works that every time a user rates something, the total vote is incremented by 1. Does anyone know what I need to do?

Source: http://community.livejournal.com/webdesign/1298510.html

Date: 08/21/07 (Java Web)    Keywords: mysql, sql

Nowadays my WordPress comments table is frequently getting corrupted and I have to repair it. The MySQL table repair command does the trick. However it is bothering me. I am suspecting there are multi-threading issues with WordPress comment processing code which is triggering as I am having huge load recently. I wonder if other bloggers [...]

Source: http://blog.taragana.com/index.php/archive/reparo-wordpress-mysql-comment-tablewhy/

Date: 08/21/07 (IT Professionals)    Keywords: asp, sql, web

Hey all-

I've got a really weird SQL issue going on with one of our web servers. SQL is generating an error to the tune of:

Type: Error
Source: SQLSERVERAGENT
Category: Alert Engine
Event ID: 318
Date: 8/21/2007
Time: 10:56:34 AM
User: N/A
Computer: (servername)
Description:
Unable to read local eventlog (reason: The data area passed to a system call is too small).

EventID.Net claims it as a few things, and none of them have really applied here. Is this indicative of a pagefile size issue, or is something more serious happening here? I'm racking my brain here, and these errors are filling up the event log to the point where it's pushing off hypothetically legit errors.

FWIW - Server Specs:

Dell PowerEdge 2850, Quad Processor, 4 gigs of memory, Server 2003, SQL 2000, IIS/ASP.net, Veritas Backup Agent for Servers, tons of HD space, all current Windows Updates (errors were occuring prior to last set of updates/reboot for updates).

Thanks for reading!

Source: http://community.livejournal.com/itprofessionals/63230.html

Date: 08/23/07 (Java Web)    Keywords: mysql, sql, spam

I was watching the mysql queries using mytop just before our server went down. In a flash I realized the cause of our persistent server load problem. I have also come up with an elegant solution which I will implement in the next few days. The problem is due to huge spam comment load on my [...]

Source: http://blog.taragana.com/index.php/archive/wordpress-server-load-problem-cause-solution/

Date: 08/23/07 (PHP Community)    Keywords: php, mysql, sql

Hello!

Just another quick question from me to you.

I simply need a little clarification on the mysql_insert_id() function that is available in PHP.

The definition on PHP.net reads: "Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query." Is this ID the number that is created in a column I defined (with Auto increment enabled) or is this something else entirely?

Say I have a table with two columns:
Column 1 = id_num (auto increment)
Column 2 = name

I want to insert a new name into the table and let the value for id_num generate automatically. Easy, right? Can I then call the mysql_insert_id() function and have it return the value in the first column that was created, or does it return a value that mysql uses but nobody else would need?

Source: http://community.livejournal.com/php/581426.html

Date: 08/28/07 (SQL Server)    Keywords: sql, web

I'm 98% sure this can be done, but I'm not finding anything on the web that explicitly says yes or no, and I want to rule out the possibility that I'm just banging my head against a wall. T-SQL, SQL Server 2005.

Can SET IDENTITY_INSERT be used on an in-memory table? e.g.,

DECLARE @m_tblOpenReceipts TABLE (
ID INT IDENTITY (1,1), (etc.)
}

...

SET IDENTITY_INSERT @m_tblOpenReceipts ON

Thanks.

Source: http://community.livejournal.com/sqlserver/63141.html

Date: 08/29/07 (PHP Community)    Keywords: php, mysql, html, sql, apache

I've wrecked my setups enough times to be a pro at getting PHP, Apache, MySQL and Windows XP to all play together nicely. However, this time I'm running into a strange problem. I've got PHP 5.2.3 and Apache 2.0.59. Apache runs fine, PHP seems to run fine, phpinfo() shows everything as it should be. When I try to load anything that seems to have more than a single line in it, it doesn't look like it's parsing anything. I get a lot of broken bits of code showing on the screen. Things like '>' when used as operators are being parsed as HTML tags. These are scripts that ran fine on Sunday with Apache 1.0.3 and PHP 4.whatever. I'm having trouble deciphering exactly what it's doing or why, but it's obvious it's not working. I'm at an end here, for now. Anyone have any suggestions?

EDIT: Found it after staring at a script for half an hour. Know what it was? From PHP.INI:

short_open_tag = On

That was set to off. Of course I'm lazy and never actually type to start a script, however, my editor sometimes puts that in for me, which is why some scripts worked. I'd read about this setting, but never thought it might apply to me.