Database

Re: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.

20-Jan-09 8:58

Do you still have the options in my.ini. That would explain the problem. Also you should check that there are no leftovers in master.info. That overrides my.ini.

The need to optimize rises from a bad design.My articles[^]

BobClarkSQL20-Jan-09 9:02

BobClarkSQL

20-Jan-09 9:02

All lines of code that pertain to the Previous Change Master are removed from the My.ini files. Is there anyway to change or verify the master .info file or Purge it?

Re: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.

Wendelius20-Jan-09 9:47

Re: I have Seven Separate MySQL Servers that Have The Same Local Databases on Each Platform that need to update each other at the completion of a run (or test). Each Server will Retain its local results and also update the other 6 Servers when it com

20-Jan-09 9:47

I don't know if they have a tool for that. You could search on their site or manuals. However, if I remember correctly, master.info is plain text so you can easily check it's contents.

The need to optimize rises from a bad design.My articles[^]

BobClarkSQL20-Jan-09 6:01

BobClarkSQL

20-Jan-09 6:01

I have Seven Separate MySQL Servers that Have The Same Local Databases on Each Platform that need to update each other at the completion of a run (or test). Each Server will Retain its local results and also update the other 6 Servers when it completes its test or run. It can run in stand alone mode if Network is Down. If Network is up it must receive the other 6 Servers Informatio as well when the other servers complete a test or run and the Network is up. What is the easiest Way to accomplish this using the free features of MySQL? Please provide examples or free utilities or code generators that can accomplish this. Regards. BC.

Ashfield21-Jan-09 0:41

Ashfield

21-Jan-09 0:41

Sounds to me like a homework question. How do YOU expect to achieve this?

BobClarkSQL wrote:
Please provide examples or free utilities or code generators that can accomplish this

Try google.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

How to use DBI Module

sk8te32019-Jan-09 22:49

sk8te320

19-Jan-09 22:49

I was wondering if someone knows how to use a DBI to exec a sql script and copy the data collect to an Excel Spreadsheet?

Re: How to use DBI Module

Reza Raad20-Jan-09 0:32

Reza Raad

20-Jan-09 0:32

What Database you ues?
If you use sql server,You can do it with a simple export with Intergration Service of SQLServer.

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: How to use DBI Module [modified]

Wendelius20-Jan-09 6:50

20-Jan-09 6:50

If you're using SQL Server there's a plenty of good articles about this on CodeProject: http://www.codeproject.com/info/search.aspx?artkw=sql+AND+server+AND+query+AND+excel&sbo=kw[^]

For example this could be a starting point: http://www.codeproject.com/KB/vb/exportdatabasetoexcel.aspx[^]

The need to optimize rises from a bad design.My articles[^]

modified on Tuesday, January 20, 2009 4:17 PM

Table Date Migration

faizurrahman19-Jan-09 20:49

faizurrahman

19-Jan-09 20:49

Urgent help Please!
I have a table exist in two database on two different server in sql server. I want to get the data of table from one table and another. When I am using OPENROWSET command it through error. I don't know what it mean. Is there any way to migrate the data. One problem is that I have a column for multi language when i migrate the date the multilingual colum show ??????? and not the original one.
thanks in advance

Re: Table Date Migration

Wendelius20-Jan-09 7:08

20-Jan-09 7:08

It would greatly help if you post the command you tried to use and the error message you got.

The need to optimize rises from a bad design.My articles[^]

Backup & Restore.

Nanda_MR19-Jan-09 20:15

Re: Backup & Restore. [modified]

19-Jan-09 20:15

Hello!

I m planning to use PostgreSQL but I have one doubt how can i take a backup.
I check some of website they refer dump command that also for LINUX How can i take backup in XP and how to restore after partition plz help me.

and i want to know where that backup file is stored.

Thanx's in advance.

Wendelius20-Jan-09 6:36

20-Jan-09 6:36

PostgreSQL uses a little bit different approach than most of DBMS's do. It creates a file containing SQL commands which can be again executed back to an empty database. This will lead to the situation where the database was when the dump was made.

Dump is taken using pg_dump or pg_dumpall utility and the result will be echoed which then again can be redirected to a file and to a place you choose.

For more info, look: SQL Dump[^]

Addition:
Of course every database can be backed up by taking copies from the files using operating system, but in order to do that, the database engine must be first shut down in order to get a consistent image.

The need to optimize rises from a bad design.My articles[^]

modified on Tuesday, January 20, 2009 12:56 PM

Nanda_MR20-Jan-09 19:38

20-Jan-09 19:38

Ya I tried it's working.
But I didn't find backup file.
Know I am format my hard disk so I'll copy that file in some removable devices after installation of XP I want run that backup file so How can i do that one ???

pass 5 hour back I am trying can't do it plzz help me.

Wendelius20-Jan-09 21:13

Re: Backup & Restore. [modified]

20-Jan-09 21:13

non-bugging Errors wrote:
But I didn't find backup file

What was the command you issued?

The need to optimize rises from a bad design.My articles[^]

Nanda_MR20-Jan-09 22:36

20-Jan-09 22:36

samp=# SELECT pg_dump -Fc -b -v -f "C:\std1.backup" samp;
ERROR: syntax error a or near ""C:\std1.backup""
LINE 1: SELECT pg_dump -Fc -b -v -f "C:\std1.backup" samp;
                                    ^

I am using above code one more thing.
1. I used SELECT and without SELECT.
2. I used different Quoted ex=",',` and empty also.
3. and other method also tried but not working. Cry | :((

if i use this code o/p come like this but i didn't got backup file.

samp=# pg_dump samp -f user\db1.dump;
       List of tablespaces
    Name    |  Owner   | Location
------------+----------+----------
 pg_default | postgres |
 pg_global  | postgres |
(2 rows)

thanx's for reply
thanx's in advance.

modified on Wednesday, January 21, 2009 4:56 AM

Wendelius21-Jan-09 5:07

21-Jan-09 5:07

pg_dump is a utility, so you run it at command prompt. For example:

pg_dump -Fc -b -v -f "C:\std1.backup" samp

The need to optimize rises from a bad design.My articles[^]

Nanda_MR21-Jan-09 20:01

21-Jan-09 20:01

Thanx's it working with database log-in parameter.

Wendelius21-Jan-09 20:08

21-Jan-09 20:08

Good to hear, you're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

RAISEERROR problem

George_George19-Jan-09 20:13

George_George

19-Jan-09 20:13

Hello everyone,

If in a store procedure, it is using SET XACT_ABORT ON (auto rollback transaction when there is error). Currently, I just rely on the output of the store procedure (when there is any errors inside) to handle success/error at client side (e.g. ADO.Net client), now I want to add RAISEERROr statement to throw the error outside to client. But I can not think of how to add RAISEERROR and fill in the related parameters for this function. Does anyone have any ideas?

Here is my pseudo code.

SET XACT_ABORT ON;

-- DML operations

commit;

thanks in advance,
George

J4amieC19-Jan-09 22:17

J4amieC

19-Jan-09 22:17

Keep it in the same discussion geoorge.

You have already been given a solution to this by Rob: http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2886661[^]

George_George20-Jan-09 2:51

George_George

20-Jan-09 2:51

Thanks J4amieC,

My question is different. Smile | :)

Whether RAISEERROR must be used in catch block? Any ideas or comments?

regards,
George

Hamid_RT22-Jan-09 23:18

Hamid_RT

22-Jan-09 23:18

Using RAISERROR[^].

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )