`ALTER TABLE ..` can be used to move tables from one database to another:

    alter table my_old_db.mytable rename my_new_db.mytable

Warning: as you asked, **this is a move, not a copy** to the new database!

But you will keep table data (and not integrity constraints if they apply in your case)

Regarding php, php is able to run sql commands so it won&#39;t be a problem.

**Entire Database (all tables):**
  
    mysqldump -u root databasename &gt; dump.sql
    mysql -u root databasename &lt; dump.sql

**One Table:**
      
    mysqldump -u root -p yourpass dbname tablename | mysql -u root -p pass secondDB

**PHP:**

Run PHP **SELECT FROM SOURCE-DB**  **TABLE** and Run **INSERT INTO Table** IN **TARGET-DB**
   

How do I, from a cell, get its `indexPath` in a `UITableView`?

I&#39;ve searched around stack overflow and google, but all the information is on the other way around. Is there some way to access the `superView`/`UITableView` and then search for the cell?

More information about the context: there are two classes that I have, one is called `Cue` and one is called `CueTableCell` (which is a subclass of `UITableViewCell`) `CueTableCell` is the visual representation of `Cue` (both classes have pointers to each other). `Cue` objects are in a linked list and when the user performs a certain command, the visual representation (the `CueTableCell`) of the next `Cue` needs to be selected. So the `Cue` class calls the `select` method on the next `Cue` in the list, which retrieves the `UITableView` from the `cell` and calls its `selectRowAtIndexPath:animated:scrollPosition:`, for which it needs the `indexPath` of the `UITableViewCell`.

How to get UITableViewCell indexPath from the Cell?

This might be a very noob question. I&#39;m just starting to learn Java

I don&#39;t understand the operation of paintComponent method. I know if I want to draw something, I must override the paintComponent method.
 
    public void paintComponent(Graphics g)
    {
       ...
    }
    
But when is it called? I never see anything like &quot;object.paintComponent(g)&quot; but still it is drawn when the program is running. 

And what is the Graphics parameter? Where is it from? Parameter must be supplied when the method is called. But as I said before, it seems like this method is never be explicitly called. So who provides this parameter? And why do we have to cast it to Graphics2D?

    public void paintComponent(Graphics g)
    {
        ...
        Graphics2D g2= (Graphics2D) g;
        ...
    }

How does paintComponent work?

How to move a table from one Database to another Database without using phpMyAdmin? It will be better if it is possible by PHP.

Move table from one database to another in MySQL

<p>How to move a table from one Database to another Database without using phpMyAdmin? It will be better if it is possible by PHP.</p>


**Introduction**

How do you Block large number of `IP address` from your web application/server. Obviously that can easily be done in `PHP` or any programming language 


	$ipList = []; // array list or from database
	if (in_array(getIP(), $ipList)) {
		// Log IP &amp; Access information
		header(&quot;https://www.google.com.ng/search?q=fool&quot;); // redirect
		exit(); // exit
	} 


Or Using `htaccess`

	order allow,deny
	deny from 123.45.6.7
	deny from 012.34.5.
	# .... the list continues
	allow from all


**The issues** 

- Am trying to block a whole `100k plus individual IPs` not `subnets`  
- Am trying to avoid user getting to PHP before blocking such IP
- 100000+ is over 1.5MB and that is a lot if information to be loading in `htaccess` all the time
- Database of IP still growing ... and they would be nee to dynamically add more values
- To set bans in `iptables` for 100000+ is just ridiculous (Might Be wrong)
 

**Stupid Idea** 

	order allow,deny
	deny from database    &lt;-------- Not sure if this is possible
	allow from all


**Question** 

- Is it possible for `htaccess` to get the list from database (Redis,Crunchbase,Mongo, MySQL or even Sqlite) ... any
- Is there a visible solution to manage such kind of issue in production 
- I know the best solution is `Block the IPs at the firewall level` is there any way to pragmatically add/remove IP to the firewall

**Finally** 

My approach might be totally wrong ... all I want is a visible solution since spammers and botnets are on the rise ...  

Please this has nothing to do with `DOS` attack its a simple ... **`get lost response`**


**Update**

- Firewall : **Cisco PIX 515UR**

How to Block 100,000+ Individual IP addresses

I&#39;m new to php and wanted to run php from command line. I have installed WAMP and set the &quot;System Variables&quot; to my php folder ( which is `C:\wamp\bin\php\php5.4.3`).

When i go to `Run` -&gt; `CMD` -&gt; Type `php -a` and hit enter, it says `interactive mode enabled`. But when I write `echo &#39;Hi&#39;;` it shows nothing.

I even don&#39;t see anything like &#39;php &gt;&quot; when i type `php -a` and hit enter.

How To Run PHP From Windows Command Line in WAMPServer

I want to use a `foreach` loop with a variable, but this variable can be many different types, `NULL` for example.

So before `foreach` I test it:

    if(is_array($var)){
      foreach($var as ...

But I realized that it can also be a class that implements `Iterator` interface. Maybe I am blind but how to check whether the class implements interface? Is there something like `is_a` function or `inherits` operator? I found `class_implements`, I can use it, but maybe there is something simpler?

And second, more important, I suppose this function exist, would be enough to check if the variable `is_array` or &quot;implements `Iterator` interface&quot; or should I test for something more?

How to check if variable is array?... or something array-like

At the end of last week I noticed a problem on one of my medium AWS instances where Nginx always returns a HTTP 499 response if a request takes more than 60 seconds.  The page being requested is a PHP script

I&#39;ve spent several days trying to find answers and have tried everything that I can find on the internet including several entries here on Stack Overflow, nothing works.

I&#39;ve tried modifying the PHP settings, PHP-FPM settings and Nginx settings. You can see a question I raised on the NginX forums on Friday (http://forum.nginx.org/read.php?9,237692) though that has received no response so I am hoping that I might be able to find an answer here before I am forced to moved back to Apache which I know just works.

This **is not** the same problem as the HTTP 500 errors reported in other entries.

I&#39;ve been able to replicate the problem with a fresh micro AWS instance of NginX using PHP 5.4.11.

To help anyone who wishes to see the problem in action I&#39;m going to take you through the set-up I ran for the latest Micro test server.

You&#39;ll need to launch a new AWS Micro instance (so it&#39;s free) using the AMI ami-c1aaabb5

This PasteBin entry has the complete set-up to run to mirror my test environment. You&#39;ll just need to change *example.com* within the NginX config at the end

http://pastebin.com/WQX4AqEU

Once that&#39;s set-up you just need to create the sample PHP file which I am testing with which is


    &lt;?php
    sleep(70);
    die( &#39;Hello World&#39; );
    ?&gt;

Save that into the webroot and then test.  If you run the script from the command line using php or php-cgi, it will work.  If you access the script via a webpage and tail the access log */var/log/nginx/example.access.log*, you will notice that you receive the HTTP 1.1 499 response after 60 seconds.

Now that you can see the timeout, I&#39;ll go through some of the config changes I&#39;ve made to both PHP and NginX to try to get around this.  For PHP I&#39;ll create several config files so that they can be easily disabled

**Update the PHP FPM Config to include external config files**

    sudo echo &#39;
    include=/usr/local/php/php-fpm.d/*.conf
    &#39; &gt;&gt; /usr/local/php/etc/php-fpm.conf

**Create  a new PHP-FPM config to override the request timeout**

    sudo echo &#39;[www]
    request_terminate_timeout = 120s
    request_slowlog_timeout = 60s
    slowlog = /var/log/php-fpm-slow.log &#39; &gt;
    /usr/local/php/php-fpm.d/timeouts.conf

**Change some of the global settings to ensure the emergency restart interval is 2 minutes**

    # Create a global tweaks
    sudo echo &#39;[global]
    error_log = /var/log/php-fpm.log
    emergency_restart_threshold = 10
    emergency_restart_interval = 2m
    process_control_timeout = 10s
    &#39; &gt; /usr/local/php/php-fpm.d/global-tweaks.conf

Next, we will change some of the PHP.INI settings, again using separate files

    # Log PHP Errors
    sudo echo &#39;[PHP]
    log_errors = on
    error_log = /var/log/php.log
    &#39; &gt; /usr/local/php/conf.d/errors.ini

    sudo echo &#39;[PHP]
    post_max_size=32M
    upload_max_filesize=32M
    max_execution_time = 360
    default_socket_timeout = 360
    mysql.connect_timeout = 360
    max_input_time = 360
    &#39; &gt; /usr/local/php/conf.d/filesize.ini

As you can see, this is increasing the socket timeout to 3 minutes and will help log errors.

Finally, I&#39;ll edit some of the NginX settings to increase the timeout&#39;s that side

First I edit the file */etc/nginx/nginx.conf* and add this to the http directive
    fastcgi_read_timeout 300;

Next, I edit the file */etc/nginx/sites-enabled/example* which we created earlier (See the pastebin entry) and add the following settings into the **server** directive

    client_max_body_size    200;
    client_header_timeout   360;
    client_body_timeout     360;
    fastcgi_read_timeout    360;
    keepalive_timeout       360;
    proxy_ignore_client_abort on;
    send_timeout            360;
    lingering_timeout       360;

Finally I add the following into the *location ~ \.php$* section of the server dir

	fastcgi_read_timeout 360;
	fastcgi_send_timeout 360;
	fastcgi_connect_timeout 1200;

Before retrying the script, start both nginx and php-fpm to ensure that the new settings have been picked up. I then try accessing the page and still receive the HTTP/1.1 499 entry within the NginX example.error.log.

So, where am I going wrong?  This just works on apache when I set PHP&#39;s max execution time to 2 minutes.

I can see that the PHP settings have been picked up by running **phpinfo()** from a web-accessible page.  I just don&#39;t get, I actually think that too much has been increased as it should just need PHP&#39;s *max_execution_time*, *default_socket_timeout* changed as well as NginX&#39;s *fastcgi_read_timeout* within just the server-&gt;location directive.

##Update 1##

Having performed some further test to show that the problem is not that the client is dying I have modified the test file to be

    &lt;?php
    file_put_contents(&#39;/www/log.log&#39;, &#39;My first data&#39;);
    sleep(70);
    file_put_contents(&#39;/www/log.log&#39;,&#39;The sleep has passed&#39;);
    die(&#39;Hello World after sleep&#39;);
    ?&gt;

If I run the script from a web page then I can see the content of the file be set to the first string. 60 seconds later the error appears in the NginX log. 10 seconds later the  contents of the file changes to the 2nd string, proving that PHP is completing the process.

##Update 2##
Setting **fastcgi_ignore_client_abort on;** does change the response from a HTTP 499 to a HTTP 200 though nothing is still returned to the end client.

##Update 3##
Having installed Apache and PHP (5.3.10) onto the box straight (using apt) and then increasing the execution time the problem does appear to also happen on Apache as well.  The symptoms are the same as NginX now, a HTTP200 response but the actual client connection times out before hand.

I&#39;ve also started to notice, in the NginX logs, that if I test using Firefox, it makes a double request (like this https://stackoverflow.com/questions/13261327/php-script-executes-twice-when-longer-than-60-seconds). Though that does appear to be the client requesting upon the script failing


NginX issues HTTP 499 error after 60 seconds despite config. (PHP and AWS)

(Sorry for my incoherent question: I tried to answer some questions as I was writing this post, but here it is:)

I&#39;m trying to create a database model with a many-to-many relationship inside a link table, but which also has a value per link, in this case a stock-keeping table. (this is a basic example for more problems I&#39;m having, but I thought I&#39;d just test it with this before I would continue).

![Database model for a basic multi-store, multi-product store-keeping system][1]

I&#39;ve used [exportmwb][2] to generate the two Entities Store and Product for this simple example, both are displayed below.

However, the problem now is that I can&#39;t figure out how to access the stock.amount value (signed int, as it can be negative) using Doctrine. Also, when I try to create the tables using doctrine&#39;s orm:schema-tool:create function

![the database layout as it is seen from HeidiSQL][4]

This yielded only two Entities and three tables, one as a link table without values and two data tables, as many-to-many relationships aren&#39;t entities themselves so I can only have Product and Store as an entity.

So, logically, I tried changing my database model to have stock as a separate table with relationships to store and product. I also rewrote the fieldnames just to be able to exclude that as a source of the problem:

![changed database layout][3]

Then what I found was that I still didn&#39;t get a Stock entity... and the database itself didn&#39;t have an &#39;amount&#39;-field.

I really needed to be able to bind these stores and products together in a stock table (among other things)... so just adding the stock on the product itself isn&#39;t an option.

    root@hdev:/var/www/test/library# php doctrine.php orm:info
    Found 2 mapped entities:
    [OK]   Entity\Product
    [OK]   Entity\Store

And when I create the database, it still doesn&#39;t give me the right fields in the stock table:

![the database layout as it is seen from HeidiSQL][5]

So, looking up some things here, I found out that many-to-many connections aren&#39;t entities and thus cannot have values. So I tried changing it to a separate table with relationships to the others, but it still didn&#39;t work.

What am I doing wrong here?


  [1]: http://i.stack.imgur.com/d7HvP.png
  [2]: https://github.com/johmue/mysql-workbench-schema-exporter
  [3]: http://i.stack.imgur.com/pyP9v.png
  [4]: http://i.stack.imgur.com/riXLG.png
  [5]: http://i.stack.imgur.com/RTlgX.png

Change limit for &quot;Mysql Row size too large&quot;

I read many threads about getting only the first row of a left join, but, for some reason, this does not work for me.

Here is my structure (simplified of course)

**Feeds**

    id |  title | content
    ----------------------
    1  | Feed 1 | ...


**Artists**

    artist_id | artist_name
    -----------------------
    1         | Artist 1
    2         | Artist 2

**feeds_artists**
    
    rel_id | artist_id | feed_id
    ----------------------------
    1      |     1     |    1 
    2      |     2     |    1 
    ...

Now i want to get the articles and join only the first Artist and I thought of something like this:

    SELECT *
        FROM feeds 
        LEFT JOIN feeds_artists ON wp_feeds.id = (
            SELECT feeds_artists.feed_id FROM feeds_artists
            WHERE feeds_artists.feed_id = feeds.id 
    	LIMIT 1
        )
    WHERE feeds.id = &#39;13815&#39;

just to get only the first row of the feeds_artists, but already this does not work.

I can not use `TOP` because of my database and I can&#39;t group the results by `feeds_artists.artist_id` as i need to sort them by date (I got results by grouping them this way, but the results where not the newest)

Tried something with OUTER APPLY as well - no success as well.
To be honest i can not really imagine whats going on in those rows - probably the biggest reason why i cant get this to work.

SOLUTION:

    SELECT *
    FROM feeds f
    LEFT JOIN artists a ON a.artist_id = (
        SELECT artist_id
        FROM feeds_artists fa 
        WHERE fa.feed_id = f.id
        LIMIT 1
    )
    WHERE f.id = &#39;13815&#39;

LEFT JOIN only first row

I want to use the jQuery UI `sortable` function to allow users to set an order and then on change, write it to the database and update it. Can someone write an example on how this would be done?

jQuery UI Sortable, then write order into a database

I want to get headerless CSV data from the output of a query to MySQL on the command line. I&#39;m running this query on a different machine from the MySQL server, so all those Google answers with &quot;INTO OUTFILE&quot; are no good. 

So I run `mysql -e &quot;select people, places from things&quot;`. That outputs stuff that looks kinda like this:

    +--------+-------------+
    | people | places      |
    +--------+-------------+
    |   Bill | Raleigh, NC |
    +--------+-------------+

Well, that&#39;s no good. But hey, look! If I just pipe it to _anything_, it turns it into a tab-separated list: 

    people  places
    Bill    Raleigh, NC

That&#39;s better- at least it&#39;s programmatically parseable. But I don&#39;t want TSV, I want CSV, and I don&#39;t want that header. I can get rid of the header with `mysql &lt;stuff&gt; | tail -n +2`, but that&#39;s a bother I&#39;d like to avoid if MySQL just has a flag to omit it. And I can&#39;t just replace all tabs with commas, because that doesn&#39;t handle content with commas in it.

So, how can I get MySQL to omit the header and give me data in CSV format?

Content Type	Original Author	Original Content on Stackoverflow
Question	Sarvap Praharanayuthan	View Question on Stackoverflow
Solution 1 - Php	user2196728	View Answer on Stackoverflow
Solution 2 - Php	GGio	View Answer on Stackoverflow

Move table from one database to another in MySQL

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

How does paintComponent work?

How to get UITableViewCell indexPath from the Cell?

Attributions