Hello.
On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.
Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.
But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.
I'm looking for a faster way. Does anybody know it? Thank you very
much.
PS: I was told about 'mysqldump', but I do not know if it's faster
than mine. 2 3956
You can do that very easily using sqlporter.
SQLPorter is total database migration toolkit from realsoftstudio.
Download your free trail from www.realsoftstudio.com
Hope this helps.
SQLPorter database migration toolkit www.realsoftstudio.com fr**********@eu rope.com (Francesco Moi) wrote in message news:<5b******* *************** ****@posting.go ogle.com>... Hello.
On MySQL, I've got a table I use as 'wild card'. I mean, I store data into it and, at the end, I dump all the date into 'production' table.
Until now, I perform it following these steps: 1) I empty 'production' table 2) I make a SELECT of every rows of the 'wild card' table and an INSERT into 'production' table. 3) I empty 'wild card' table.
But I've got problem: during SELECT+INSERT time, 'production' table is not full and there's a data lack.
I'm looking for a faster way. Does anybody know it? Thank you very much.
PS: I was told about 'mysqldump', but I do not know if it's faster than mine.
You can do that very easily using sqlporter.
SQLPorter is total database migration toolkit from realsoftstudio.
Download your free trail from www.realsoftstudio.com
Hope this helps.
SQLPorter database migration toolkit www.realsoftstudio.com fr**********@eu rope.com (Francesco Moi) wrote in message news:<5b******* *************** ****@posting.go ogle.com>... Hello.
On MySQL, I've got a table I use as 'wild card'. I mean, I store data into it and, at the end, I dump all the date into 'production' table.
Until now, I perform it following these steps: 1) I empty 'production' table 2) I make a SELECT of every rows of the 'wild card' table and an INSERT into 'production' table. 3) I empty 'wild card' table.
But I've got problem: during SELECT+INSERT time, 'production' table is not full and there's a data lack.
I'm looking for a faster way. Does anybody know it? Thank you very much.
PS: I was told about 'mysqldump', but I do not know if it's faster than mine. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Francesco Moi |
last post by:
Hello.
On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.
Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
|
by: Eric Robinson |
last post by:
Our database just slowed down radically. Certain queries drive CPU
utilization through the roof. This happened once before, and the technican
simply dumped the data to disk and then played it back in. This seemed to
correct database corruption. After than, the database went back to normal
performance. Does anyone know how to do this?
--Eric
|
by: Victor Spång Arthursson |
last post by:
Hi!
Have a problem, probably easy to solve... I want to dump a database
which resides on my local server with another, and not existing, owner
than the one who actually owns it locally.
The beginning of the dump file looks like:
########
\connect - postgres
|
by: D. Dante Lorenso |
last post by:
First I created a function that selected the next available pin
code from a table of pre-defined pin codes:
CREATE FUNCTION "public"."get_next_pin_code" () RETURNS varchar AS'
DECLARE
my_pin_code VARCHAR;
BEGIN
...
/* this is the pincode we just fetched */
RETURN (my_pin_code);
|
by: Együd Csaba |
last post by:
Hi All,
I'd like to dump out my database using plain text format. Everything is ok,
but the bytea filds.
Restoring the dump file (using <<psql -f LO_TRY_INSERT_BYTEA.sql tmp7>>) it
sends an error message like
psql:LO_TRY_INSERT_BYTEA.sql:14: ERROR: Bad input string for type bytea
Trying dumping with copy commands it sends this error:
psql:LO_TRY_COPY_BYTEA.sql:13: lost synchronization with server, resetting
| |
by: John Liu |
last post by:
We upgraded from 7.2 to 7.4, it looks like everything working, but when I
issue a query such as select * from tab (tab has about 2-3 million records),
it causes core dump. I tuned some the parameters, it still produce the core.
Thanks for any hints.
|
by: Soeren Gerlach |
last post by:
Hi,
some weeks ago I started to develop an application using Postgresql the
first time. I'm running 7.4.3 on a Linux box with a plain 2.6.7 kernel, the
storage is handled by 5 SATA disks, managed by a 3ware controller and using
a xfs filesystem. The DB server is a 3 Ghz P4 with 4 Gig of Ram, so the
machine is quite fast for most purposes I need it; the DB server is a pure
DB server, theres no application running on it.
I dump and...
|
by: Rakesh |
last post by:
Hi -
What is wrong this implementation? I get a core dump at the free()
statement? Thanks
Rakesh
#include <ext/hash_map>
#include <iostream.h>
#include <ext/hash_set>
|
by: capnwhit |
last post by:
Hello all,
The program below has a bug... The program is supposed to convert a
string to a continuous hex dump and back to a string. The output
should be as follows:
abcd
61626364
abcd
|
by: yasmine |
last post by:
Hi friends,
can anyone tell me how can I read dump values from one database to another?
I can't understand the dump concept properly. can anybody explain it?
what command we have to use to dump tables?
I have to dump one large table from one database to another.
what is the command for it?
Please help me out.
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |