How to copy database from one machine to another machine in MYSQL? Explain with an example?

bagya

 Profile Answers by bagya Questions by bagya

• Jul 31st, 2009

Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';

soorajVs

 Profile Answers by soorajVs Questions by soorajVs

• Mar 6th, 2008

Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql

Answer Question  Select Best Answer

If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?

ramavenky

 Profile Answers by ramavenky Questions by ramavenky

• Feb 19th, 2010

Check for Buffer Cache SizeCheck For Poor SQL Query

kven_sat

 Profile Answers by kven_sat Questions by kven_sat

• Aug 8th, 2008

Remove unnecessary joins,? too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me

Answer Question  Select Best Answer

How to find how many tables in each data base

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

what abt this ?  1* select sum(count(*)) from all_tables group by ownerSQL> /SUM(COUNT(*))-------------           39SQL>

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

Someone need to confirm whether this is correct! Each owner is treated as schema(?),bang me if I am wrong  1* select count(1),owner from all_tables group by ownerSQL> /  COUNT(1) OWNER---...

Answer Question  Select Best Answer

How to Connect MySQL with XML?

hanumanbaba

 Profile Answers by hanumanbaba Questions by hanumanbaba

• Mar 21st, 2009

use strict; use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "testuser", "testpass", { RaiseError => 1,...

hanumanbaba

 Profile Answers by hanumanbaba Questions by hanumanbaba

• Mar 20th, 2009

adoConn.Open("Driver={MySQL ODBC 5.1 Driver};Server=VBNET4;Port=3306; Database=netmusk; User=admin; Password=pass123;Option=3; Min Pool Size=5; Max Pool Size=60; Connect Timeout=2;");

Answer Question  Select Best Answer

How to perform 1st and 2nd normalization? Explain with example.

anushandilya123

 Profile Answers by anushandilya123 Questions by anushandilya123

• May 8th, 2009

For a relation to be in 1st NF the relation should contain atomic attributes only that is they must be single-valued. If its not so break the composite attribute into its parts and for multivalued...

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Feb 16th, 2009

1st Normalization specifies  if and only if all the attributes of the relation R are atomic in nature.Ex: First (Empno, Prjno, Prjname, Noof Hours, Empname)Empno: Employee numberPrjno: Project nu...

Answer Question  Select Best Answer

Explain the steps involved in creating JDBC connection?

mfsi_chinmayb

 Profile Answers by mfsi_chinmayb Questions by mfsi_chinmayb

• Apr 6th, 2012

For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html

Shravan Mahendra

 Profile Answers by Shravan Mahendra Questions by Shravan Mahendra

• Mar 31st, 2010

Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goesStep-1: JDBC Driver loading which will be as follows         Class.forName("o...

Answer Question  Select Best Answer

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Feb 3rd, 2007

Lists of Values (LOVs) enable end users to choose entry field values in a form or database portlet customization form.

E.gomathi

• Feb 7th, 2006

LOV is list of values, used to popup the single or multiple values at run time

Answer Question  Select Best Answer

Before report, Before form, After form , Between page, After report.

Prasant

• Nov 23rd, 2006

There are 3types of trigger available in report1.Report triggerbefore parameter formAfter parameter formBefore reportBetween pageAfter report2.Data Model TriggerFormula triggerGroup filter3.Layout TriggerFormat Trigger

imran zaher

• May 23rd, 2006

sequence of execution of the various report triggersBefore form , After form , Before report, Between page, After report.

Answer Question  Select Best Answer

Piyush Pathak

• Feb 1st, 2018

$$DBDATE$$ retrieves the current database or the server you using date
$$date$$ retrieves the current operating system or the current system you are working date.

palani

• Apr 26th, 2006

$$date$$ displaying local system date $$dbdate$$ displaying server date.

Answer Question  Select Best Answer

Connect as sydba Write a LOGON trigger like this� � �CREATE OR REPLACE TRIGGER RESTRICT_TOOL�AFTER LOGON ON DATABASEDECLARE� �L_TOOL �V$SESSION.PROGRAM%TYPE;BEGIN�SELECT PROGRAM�INTO L_TOOL�FROM V$SESSION�WHERE �AUDSID = USERENV('SESSIONID')� �AND �AUDSID != (SELECT AUDSID� � � � � � � � � �FROM V$SESSION� � � � � � � � � �WHERE USERNAME='SYS');�IF UPPER(L_TOOL) LIKE '%TOAD%'�OR UPPER(L_TOOL) LIKE...

Laxmi Kant Sharma

• Aug 30th, 2007

This solution is not working properly.. because it is not raised after logon. so there is no use of raise_application_error after login. Is there any other method for that?

Dinesh G

• Aug 6th, 2005

Above shown trigger won't work if user system. Same will happen if any use opts the as sysdba option.  Is there any way to close these loop holes ?

Answer Question  Select Best Answer

Three types,they are object-based logic models,record-based logic models,and physical models.

anushandilya123

 Profile Answers by anushandilya123 Questions by anushandilya123

• May 8th, 2009

Data Models:
Object based
Record based

Object Based:
Object Oriented
Entity Relationship Model

Record Based:
Relational
Network
Hierarchical

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of ...

Answer Question  Select Best Answer

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Mar 11th, 2006

Select count(empid),d.deptname from emp, dept d where d.deptno=emp.deptno group by deptno

madhu

• Feb 23rd, 2006

the query isselect d.dname,count(*)from emp e, dept dwhere e.deptno = d.deptnogroup by d.dname

Answer Question  Select Best Answer

Laxmi Prasad

• Apr 2nd, 2007

U can call that data using database name.tablename.fields

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

since the data is in two different tables you have two different choices, JOIN or UNION.  In this case you would probably use UNION. However you can make it much simpler by just leaving the data ...

Answer Question  Select Best Answer

Ramasamy PL

• Jul 24th, 2006

The trigger followed by a DML Operation is called dml triggers.Here the constraint is table used by the DML operation cant be used by trigger.Voiding this will to runtime error.

missoracle

• Jul 18th, 2006

Wrap :- this is used to encript the PL/SQL .sql file.

Answer Question  Select Best Answer

sanjeev

• Aug 6th, 2007

In session properties we have the target commit interval. There we need to mention the commit interval as 1000.Sanjeev

Rajesh

• Oct 10th, 2006

Yes, we have different logic to accomplish this thing in Informatica. You use either sequence generator and Filter transformation or Expresion and Fileter transformation. If you are sorting and loadin...

Answer Question  Select Best Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 25th, 2008

B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.

hemshikha

• Sep 1st, 2006

Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values?such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...

Answer Question  Select Best Answer

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

Subject AreasParty,Party Asset,Location,Campaign,product .................

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

FSLDM COnsists of 10 Subject Areasparty,party asset,address,compaign.......

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

You can store the images in oracle database as BLOBS (Binary Large OBjetcS).

Priya

• Oct 15th, 2006

S, u can upload the image in data base,by taking datatype as Image.

Answer Question  Select Best Answer

aju_mech

 Profile Answers by aju_mech Questions by aju_mech

• Jul 25th, 2007

Prompts in MicroStrategy are used for Manipulating data in report while executing it. For Ex. If there is a report with attribute region and Profit Metrics and having a prompt on region attr...

S

• Oct 25th, 2006

A prompt is a MicroStrategy object that allows userinteraction at report run time. The user is asked during the report execution to provide an answer tocomplete the information.Uses:Prompts are useful...

Answer Question  Select Best Answer

A  property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on  it.  An  object  based  on  a  property  can inherit the setting of any property in the clause that makes sense for that object.

fastfreeeasy

 Profile Answers by fastfreeeasy Questions by fastfreeeasy

• Jul 26th, 2007

If you are talking about Developer/2000 then this is not Property Clause rather Property Class. One more thing is that change of visual attribute of an item is possible programatically but the same is...

Answer Question  Select Best Answer