    Usage: mysqldump [OPTIONS] database [tables]

i.e.

    mysqldump -u username -p db_name table1_name table2_name table3_name &gt; dump.sql

If you&#39;re in local machine then use this command

    /usr/local/mysql/bin/mysqldump -h127.0.0.1 --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] &gt; /to/path/tablename.sql;

For remote machine, use below one

    /usr/local/mysql/bin/mysqldump -h [remoteip] --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] &gt; /to/path/tablename.sql;

I am trying to write the following query on postgresql:

	select name, author_id, count(1), 
		(select count(1)
		from names as n2
		where n2.id = n1.id
			and t2.author_id = t1.author_id
		)				
	from names as n1
	group by name, author_id

This would certainly work on Microsoft SQL Server but it does not at all on postegresql. I read its documentation a bit and it seems I could rewrite it as:

	select name, author_id, count(1), total						
	from names as n1, (select count(1) as total
		from names as n2
		where n2.id = n1.id
			and n2.author_id = t1.author_id
		) as total
	group by name, author_id

But that returns the following error on postegresql: &quot;subquery in FROM cannot refer to other relations of same query level&quot;. So I&#39;m stuck. Does anyone know how I can achieve that?

Thanks

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?

I am running Linux (2.6.18-164.15.1.el5.centos.plus) and trying to install pyodbc.  I am doing pip install pyodbc and get a very long list of errors, which end in 

&gt; error: command &#39;gcc&#39; failed with exit status 1


I looked in  **/root/.pip/pip.log** and saw the following:

&gt; InstallationError: Command /usr/local/bin/python -c &quot;import setuptools; __file__=&#39;/home/build/pyodbc/setup.py&#39;; execfile(&#39;/home/build/pyodbc/setup.py&#39;)&quot; install --single-version-externally-managed --record /tmp/pip-7MS9Vu-record/install-record.txt failed with error code 1


Has anybody had a similar issue installing pyodbc?

Unable to install pyodbc on Linux

If my database has 10 tables and I want to dump only 3 tables. Is it possible with `mysqldump` command?

How to dump only specific tables from MySQL?

<p>If my database has 10 tables and I want to dump only 3 tables. Is it possible with <code>mysqldump</code> command?</p>


I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump installed. I would like to use the mysqldump on my machine to connect to the remote database and do the dump on my machine.

I have tried to create an ssh tunnel and then do the dump, but this does not seem to work. I tried:

    ssh -f -L3310:remote.server:3306 user@remote.server -N

The tunnel is created with success. If I do 

    telnet localhost 3310

I get some blurb which shows the correct server mysql version. However, doing the following seems to try to connect locally

    mysqldump -P 3310 -h localhost -u mysql_user -p database_name table_name



how to mysqldump remote db from local machine

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?

In what cases should these be used?

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?

I need to insert a couple hundreds of millions of records into the mysql db.  I&#39;m batch inserting  it 1 million at a time.  Please see my code below. It seems to be slow.  Is there any way to optimize it?

    try {
            // Disable auto-commit
            connection.setAutoCommit(false);

            // Create a prepared statement
            String sql = &quot;INSERT INTO mytable (xxx), VALUES(?)&quot;;
            PreparedStatement pstmt = connection.prepareStatement(sql);

            Object[] vals=set.toArray();
            for (int i=0; i&lt;vals.length; i++) {
                pstmt.setString(1, vals[i].toString());
                pstmt.addBatch();
            }

            // Execute the batch
            int [] updateCounts = pstmt.executeBatch();
            System.out.append(&quot;inserted &quot;+updateCounts.length);


JDBC batch insert performance

I&#39;m new to MySQL, I&#39;m trying to run WordPress in my Windows desktop and it needs MySQL.

I install everything with `Web Platform Installer` which is provided by Microsoft. I never set a root password for MySQL and in the final step of installing WordPress, it asks for a MySQL server password.

What is the default password for root (if there is one) and how to change it?

I tried:

    mysql -u root password &#39;123&#39;

But it shows me:

    Access denied for user &#39;root@localhost&#39; (using password:NO)

After this I try:

    mysql -u root -p

However, it asks for a password which I don&#39;t have.

---

**Update**: as Bozho suggested, I did the following:

 1. I stopped the MySQL Service from Windows services
 2. Opened CMD
 3. Changed the location to c:\program files\mysql\bin
 4. Executed the command below

    `mysqld --defaults-file=&quot;C:\\program files\\mysql\\mysql server 5.1\\my.ini&quot; --init-files=C:\\root.txt`

 5. The command ran with a warning about character set which I mentioned below
 6. I start the MySQL service from Windows services
 7. I write in the command line

    `mysql -u root -p`
    `EnterPassword: 123  // 123 was the password`

 8. The command line shows the following error

    `Access denied for user &#39;root@localhost&#39; (using password:**YES**)`

How do I solve this? I&#39;m waiting to hear from you.


Access denied for user &#39;root@localhost&#39; (using password:NO)

what&#39;s faster?

    DELETE FROM table_name;

or

    DELETE FROM table_name where 1=1;

why?

does `truncate table` work in access?

Content Type	Original Author	Original Content on Stackoverflow
Question	Harish Kurup	View Question on Stackoverflow
Solution 1 - Mysql	Lauri Lehtinen	View Answer on Stackoverflow
Solution 2 - Mysql	Raja Bose	View Answer on Stackoverflow

How to dump only specific tables from MySQL?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Unable to install pyodbc on Linux

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?

Attributions