Hello, I have a mysqldump file of multiple databases (5). One of the database takes a very long time to load, is there a way to either split the mysqldump file by database, or just tell mysql to load only one of the specified databases? Manish ...
let's say i want to implement a distributed database (each node being the replica of the others); i hear that cdb is able to easily sync between two nodes and at least support some form of conflict resolution. unfortunately i don't know couchdb therefore i have to ask: how's the situation for a "graph" of nodes? let's say we have a thou...
Hi, I need to have a way to iterate through a database table without actually storing it in memory anywhere. I want to essentially read through the rows like an input iterator. I've tried using cursors with a select statement (select * from table_name), but this retrieves the entire table and feeds it back to be one row at a time. So ...
Hi I need to add a download counter to know how many times my BLOB data is read and displayed from the database (to determine traffic). How and where can I add this counter? Many thanks! I have a dynamically generated list of links such as <a href="page.aspx?DocID=IDhere">Document filename</a> which direct to a display page. My displ...
I have a small database that I need help designing. I have a VB.NET program that gets data from a .csv file and enters the data into an Access database. The data is from a "Runway Friction Test". A machine measures the level of friction on a runway due to rubber build up from airplanes landing and puts the data into a .csv file. I n...
i have a database that has 50 tables and all the tables have primary key on a field named ID. so example, Employee.ID, Customer.ID, order.ID, every single table has ID as its primary key. should it not be Employee.Employee_ID, Customer.Customer_ID and so on? is there any drawback of using ID as name of every ID field in each table? if so...
*UPDATE, seems like the answer was given, but the SQL query his erroring out.. can anyone help? See the first answer, i posted the problem there. So to put this simply. I have 3 tables. An "item" table and a "tag" table. Then I also have an "item_tag" table which ties the 2 together. I want to make a query that lists all the items ...
I have these two classes in my database package:(DBManager and TaskManager class) and I create a new object in my main frame which is in the other package and I also imported the database package for my main frame and I call addBirth() on my object,and I want to insert these arguments in my table="birthsql" in MySQL but I found this exce...
I issued a command of: DROP USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON . TO 'root'@'%'; ...in PhpMyAdmin. Immediately after the execution, I was forced out PhpMyAdmin. I got: error #1130 - Host 'localhost' is not allowed to connect to this MySQL server, how to resolve my problem? ...
In addition to inserting a new row into a table for each item of work being processed, an additional update is done to a separate row in a different table that contains some kind of summary data (e.g. totals) relating to a portion of the rows being inserted into the first table. This single row however can therefore become a bottleneck ...
I am building a site for a magazine that includes three different sections- articles, blog posts, and reviews. All three of these object types have the following columns in common: title, description, headline, subheadline, body, and author. Should I store them each in their own table, or should I just create one Posts table and add a ca...
I did a wipe and restore. I backedup my current innodb tables. (mysqldump) I loaded it into the database. For some reason...the tables are now all myisam instead of innodb...weird! I try to do: ALTER TABLE xxx ENGINE=innodb; And it doesn't do anything to any table. "Show table status" still is "MyISAM" mysql> alter table auth_use...
I am creating a web app that will use OpenID logins and OAuth tokens with Youtube. I am currently storing the OpenID identity and OAuth token/token secret in plain text in the database. Is it inappropriate to store these values as plain text? I could use a one-way encryption for the OpenID identifier but I don't know if that is necess...
I have these two classes in my database package:(DBManager and TaskManager class) and I create a new object in my main frame which is in the other package and I also imported the database package for my main frame and I call addBirth() on my object,and I want to insert these arguments in my table="birthsql" in MySQL but I found this stac...
A WPF application should be a visualizer front-end for a ERP database (in fact only small part of it). They are connected trough web services. What are main rules for designing a data model class structure for mapping database tables? For example, should it be a one big flat class with lots of members, or lots of classes representing di...
Our product takes tests of some 350 candidates at the same time. At the end of the test, results for each candidate are moved to a datawarehouse full of indexes on it. For each test there's some 400 records to be entered in datawarehouse. So 400 x 350 is a lot of records. If there are not much records in the datawarehouse, all goes well....
i have a table with products and the user can choose which regions and cities he wants to let them be visible to. he can choose ALL REGIONS and ALL CITIES from a drop down menu and then i will put in the columns = 0. the the buyers can choose which city they want to watch products from so they aslo have a drop down menu to pick a region...
Hi all, I'm using the tiny mce editor in my website and I want to load some text from database in the text area that uses tinymce. The javascript configuration for the editor is the following: <script type="text/javascript"> tinyMCE.init({ mode : "textareas", theme : "advanced", editor_selector : "mceAdvanced", plugins ...
We are using VS2008 deployment for our databases [database solutions in VS where each one has their own schema.] The script it produces does not work quite well. "Before deployment it compares the server objects and then creates the script" is the way msdn is telling, but obviously it tries to create objects those exist, or tries to drop...
i want to run a routine backup of my database from my java application. i'm actually considering a cron job within quartz to fire the backups at the specified time, but i don't know if thats the proper and most efficient way to do it. are there any other ways i can do it? and is there anything i should look out for?? ...