Import/export large mysql databases
Which scripts/solutions do use for import and export large mysql databases? Phpmyadmin gives an error for these operations, if there is a big amount of data. ...
database
Automatically generate value for a column in database
I've an existing table with 'creation time' column in one of the table. I want the value of it to be generated automatically by the Oracle when the row gets inserted, instead of me populating in the application. Thank You ...
Ms Access replace issue.
So, I have to update a database with 6000 lines of duplicates. The duplicates are companies who all share a common number code. My issue is I'm only replacing one or two fields at a time, ie company web site that was provided in 2009 but they didn't give it in 2010. This is all that needs to be replaced. I'm an access rookie and am doing...
New App Data Decision
A group has been using a VB app for a while and it uses an access db as its data storage. I've been tasked with completely redoing this in java. The application will be self-contained with the data local (with internet updates), but not a central connection to a db. So installation and local setup is a consideration. The access db is...
Utilizing the power of clusters in the context of databases?
I have a 22 machine cluster with a common NFS mount. On each machine, I am able to start a new MySQL instance. I finished creating a table with about 71 million entries and started an ADD INDEX operation. It's been more than 12 hours and the operation is still going on. So what I logged onto one of my other machines in the cluster, start...
Table with 80 million records and adding an index takes more than 18 hours (or forever)! Now what?
A short recap of what happened. I am working with 71 million records (not much compared to billions of records processed by others). On a different thread, someone suggested that the current setup of my cluster is not suitable for my need. My table structure is: CREATE TABLE `IPAddresses` ( `id` int(11) unsigned NOT NULL auto_incremen...
scalable layout for storing and displaying user uploaded images
I am trying to figure out the best way to layout my directory structure so that I can store images from multiple users in a way that would be scalable when used in combination with a database. The database will store the absolute path to each image. So lets assume I was dealing with users' profile images each of which would have thumbn...
Improving efficiency of SQL selects and joins in sqlite
I'm working on a personal project focusing on analysis of text in a database. My intent is to do something interesting and learn about SQL and sqlite. So with my novice abilities in mind, I'd like to get advice on doing this more efficiently. Say, for example, I want to pick out the types of food in an article A. I parse my article, ...
Date / Time reference table needed for Analytic?
Is it better to keep Days of month, Months, Year, Day of week and week of year as separate reference tables or in a common Answer table? Goal is allow user content searches and action analytic to be filtered by all the various date-time values (There will be custom reporting for users based on their shared content). I am trying to ensure...
Create a view from table with dynamic where clause
I have a table with a column called YEAR. I would like to create a view from this table, with YEAR always equal to the one with max value. Whenever new records with YEAR values greater than the current max one are inserted, the view would automatically be reflected accordingly. Is this possible and if so how can I accomplish that. ...
Best practices for database testing with PHPUnit
PHPUnit's own manual has some as-yet-unwritten sections entitled "Operations" and "Database Testing Best Practices." What are best practices for testing a database with PHPUnit, particularly in MySQL? ...
find the date of last update to sqlite in iphone
i have a database in iphone which is regularly updated. is there a way to find out the date of last update to the database. i just need the date and not the data. also don't want to store the date of update as a extra column. ...
Difference between Database and Data Source
What is the difference between Database and Data Source? ...
Storing Huge Amount of Files in the Application Bundle
Um, I working on a dictionary app and currently trying to add narration for each article. I have about 97000 AAC-files. They are tiny - about 3-5 kilobytes each, but there are so many of them! I don't need SQL DB for access management because filenames are identical to the primary keys, so given the key I will be able to pick a proper so...
Implementing arrays in MySQL
Is there any provision for creating arrays (variable length would be preferable) in MySQL . I need to create 2-3 lists for each user and update/append/delete items from the lists . How do I implement them? . Creating tables for each user will lead to a total mess in my opinion, but anyway I'm new to MySQL so please help me out . Thanks ...
Changing CommandText changes Parameters
I'm trying to edit the CommandText for the Insert Command in a TableAdapter in the Designer in vb.net. Whenever I make changes to the CommandText, Visual Studio (2008) automagically changes the Parameters to a Collection consisting of one Parameter that existed before editing the Command, immersed in a sea of complete garbage Parameters,...
save file as lob or as OS file?
hello, I am developing a J2EE application that manages hundreds of jars (saved and loaded on the fly) to manage them i have two options: create a directory on the server that contains all the jars save the jar as a LOB in an oracle 10g database Could you help me to choose the best solution?What are the benefits of each option? than...
Different database tables joining on single table
So imagine you have multiple tables in your database each with it's own structure and each with a PRIMARY KEY of it's own. Now you want to have a Favorites table so that users can add items as favorites. Since there are multiple tables the first thing that comes in mind is to create one Favorites table per table: Say you have a table ...
[unit-testing] Distinquish between 0 and some datasets from db (both valid cases)
Hi, currently I'm using phpunit to write tests for some functions that access a mysql-database. Now I'm unsure what to do to distinguish when a function returns some datasets or nothing (which both are valid function results). Should I use different tests (so that one of them will fail in any case) or is it in this case ok to use an if t...
Database constraints - keep or ignore?
When I was learning in university, they taught us the database fundamentals, basics and rules, and one of the most important rules is the constraints (primary key, foreign key), and how to make 1-m, 1-1, m-n relationships. Now when I move to real business environment they tell me: you should forget all you have been taught; no constrain...