Yes, you can navigate to the table you want and then go to (tab) *Operations* &gt; *Copy table to (database.table):*, which is a box on the right hand side. There you can define into which database and under what name you&#39;d like to copy your table. After having done than you get the SQL &quot;spat out&quot;.  

As I&#39;m not completely sure about your question, if you&#39;d like to have the table in a dump file, you could alternatively click the tab *Export*, where you can get the SQL as well, or download the dump file straight away.

You can use the Export tab to select which table to export. In the diagram below,

- the album table is specified
- Structure is checked
- Data is unchecked - to not generate data with the export
- SQL radio button is checked
- ...
- Click on the Go button at the bottom to have the generated SQL

![enter image description here][1]


  [1]: http://i.stack.imgur.com/kz92n.png

I have something to do for work and I need your help.
We want to implement a `FSM - Finite State Machine`, to identify char sequence(like: A, B, C, A, C), and tell if it accepted.

We think to implement three classes: `State`, `Event` and `Machine`.
The `state` class presents a node in the `FSM`, we thought to implement it with `State design pattern`, every node will extend from the abstract class state and every class would handle different types of events and indicate transitions to a new state. Is it good idea in your opinion?

Second thing, we don&#39;t know how to save all the transitions. Again we thought to implement it with some kind of `map`, that hold the starting point and gets some kind of vector with the next states, but I&#39;m not sure thats a good idea. 

I would be happy to get some ideas of how to implement it or maybe you can give me some starting points.

How should I save the FSM, meaning how should I build the tree at the beginning of the program?
I googled it and found a lot of examples but nothing that helps me.

Thanks a lot.

How to implement a FSM - Finite State Machine in Java

Apologies if this question has already been raised and answered.
What I need to do is very simple in concept, but unfortunately I have not been able to find an answer for it online.

I need to create dynamic functions in Python (Python2.7) with custom names at runtime. The body of each function also needs to be constructed at runtime but it is (almost) the same for all functions.

I start off with a list of names.

    func_names = [&quot;func1&quot;, &quot;func2&quot;, &quot;func3&quot;]

Note that the func_name list can hold a list of arbitrary names, so the names will NOT simply be func1, func2, func3, ....

I want the outcome to be :

        def func1(*args):
            ...

        def func2(*args):
            ...

        def func3(*args):
            ...


The reason I need to do this is that each function name corresponds to a test case which is then called from the outside world.

**update**: There is no user input. I&#39;m tying two ends of a much bigger module. One end determines what the test cases are and among other things, populates a list of the test cases&#39; names. The other end is the functions themselves, which must have 1:1 mapping with the name of the test case. So I have the name of the test cases, I know what I want to do with each test case, I just need to create the functions that have the name of the test cases. Since the name of the test cases are determined at runtime, the function creation based on those test cases must be at runtime as well.

**update**: I can also wrap this custom named functions in a class if that would make things easier.

I can hard-code the content of the functions (since they are almost the same) in a string, or I can base it off of a base class previously defined. Just need to know how to populate the functions with this content.

For example:

        func_content = &quot;&quot;&quot;
                       for arg in args:
                           print arg
                       &quot;&quot;&quot;
                       
Thanks in advance,

Mahdi


Python dynamic function creation with custom names

Is there some way to get phpMyAdmin to spit out the SQL needed to duplicate the table in another DB?

I saved it when I initially made the table but I&#39;ve changed it quite a bit since then. It&#39;s a pretty big table and this would really help.



phpMyAdmin Duplicate Table

<p>Is there some way to get phpMyAdmin to spit out the SQL needed to duplicate the table in another DB?</p>
<p>I saved it when I initially made the table but I've changed it quite a bit since then. It's a pretty big table and this would really help.</p>


E.g. I have a link

    http://img.youtube.com/vi/aOPGepdbfpo/0.jpg

for a youtube video thumbnail:

![enter image description here][1]

And I would like to remove the black top and bottom border so I get a picture like this:

![enter image description here][2]


  [1]: http://i.stack.imgur.com/4TTp5.jpg
  [2]: http://i.stack.imgur.com/ytbV7.jpg


Could it be done using PHP function javascript/jQuery or maybe youtube api itself?

Removing black borders 4:3 on youtube thumbnails

I was running the following [PHP][1] code:

    &lt;?php 
        &lt;/script&gt;
    ?&gt;

There were no parse errors and the **output was** &quot;`?&gt;`&quot; ([example][2]).

In similar cases I do get a parse error:

    &lt;?php 
        &lt;/div&gt;
    ?&gt;

&gt; Parse error: syntax error, unexpected &#39;&lt;&#39; in ...

Why doesn&#39;t `&lt;?php &lt;/script&gt; ?&gt;` give the same error?

  [1]: http://en.wikipedia.org/wiki/PHP
  [2]: http://ideone.com/0FbOdx


In PHP, why does &lt;/script&gt; not show a parse error?

In `RegEx`, I want to find the tag and everything between two `XML tags`, like the following:

	&lt;primaryAddress&gt;
		&lt;addressLine&gt;280 Flinders Mall&lt;/addressLine&gt;
		&lt;geoCodeGranularity&gt;PROPERTY&lt;/geoCodeGranularity&gt;
		&lt;latitude&gt;-19.261365&lt;/latitude&gt;
		&lt;longitude&gt;146.815585&lt;/longitude&gt;
		&lt;postcode&gt;4810&lt;/postcode&gt;
		&lt;state&gt;QLD&lt;/state&gt;
		&lt;suburb&gt;Townsville&lt;/suburb&gt;
		&lt;type&gt;PHYSICAL&lt;/type&gt;
	&lt;/primaryAddress&gt;

I want to find the tag and everything between `primaryAddress`, and erase that. 

Everything between the `primaryAddress` tag is a variable, but I want to remove the entire tag and sub-tags whenever I get `primaryAddress`.

Anyone have any idea how to do that?

Find everything between two XML tags with RegEx

I want to read a file line by line, but without completely loading it in memory.

My file is too large to open in memory, and if try to do so I always get out of memory errors.

The file size is 1 GB.

How to read a large file line by line?

I need to take an array like I have below:

    $subids = Array
        (
            [s1] =&gt; one
            [s2] =&gt; two
            [s3] =&gt; three
            [s4] =&gt; four
            [s5] =&gt; five
            [s6] =&gt; six
        )

and generate a URL such as http://example.com?s1=one&amp;s2=two&amp;s3=three=&amp;s4=four&amp;s5=five&amp;s6=six

All of the subids are not always defined, so sometimes s3 may not be defined, so it shouldn&#39;t be appended to the URL. Additionally, whatever the first subid is, it has to have the ? preceding it instead of the ampersand (&amp;)

So if the array is just:

    $subids = Array
        (
            [s2] =&gt; two
            [s6] =&gt; six
        )

then the URL needs to be http://example.com?s2=two&amp;s6=six

I have the following so far:

$url = &#39;http://example.com&#39;

        foreach ($subids AS $key =&gt; $value) {
            $result[$id][&#39;url&#39;] .= &#39;&amp;&#39; . $key . &#39;=&#39; . $value;
        }

However, I&#39;m not sure what the best way would be to append the ? at the beginning of the first key/value pair.

I feel like there&#39;s a PHP function to help with this but I&#39;m not finding much. I&#39;m using Codeigniter if there&#39;s anything I can use that is provided by CI.

Generate URL with parameters from an array

After I did `brew update` and `brew upgrade`, my postgres got some problem. I tried to uninstall postgres and install it again, but it didn&#39;t work as well. 

This is the error message. (I also got this error message when I try to do `rake db:migrate`)

&lt;!-- language: lang-none --&gt;

    $ psql
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket &quot;/tmp/.s.PGSQL.5432&quot;?

How can I solve it?

Mac version: Mountain lion.

homebrew version: 0.9.3

postgres version: psql (PostgreSQL) 9.2.1

And this is what I did:

&lt;!-- begin snippet: js hide: true console: false babel: false --&gt;

&lt;!-- language: lang-js --&gt;

    $ brew uninstall postgresql
    Uninstalling /usr/local/Cellar/postgresql/9.2.1...
    $ brew uninstall postgresql
    Uninstalling /usr/local/Cellar/postgresql/9.1.4...
    $ psql --version
    bash: /usr/local/bin/psql: No such file or directory
    $ brew install postgresql
    ==&gt; Downloading http://ftp.postgresql.org/pub/source/v9.2.1/postgresql-9.2.1.tar.bz2
    Already downloaded: /Library/Caches/Homebrew/postgresql-9.2.1.tar.bz2
    ......
    ......
    ==&gt; Summary
    /usr/local/Cellar/postgresql/9.2.1: 2814 files, 38M, built in 2.7 minutes
    $ initdb /usr/local/var/postgres -E utf8
    The files belonging to this database system will be owned by user &quot;laigary&quot;.
    This user must also own the server process.

    The database cluster will be initialized with locale &quot;en_US.UTF-8&quot;.
    The default text search configuration will be set to &quot;english&quot;.

    initdb: directory &quot;/usr/local/var/postgres&quot; exists but is not empty
    If you want to create a new database system, either remove or empty
    the directory &quot;/usr/local/var/postgres&quot; or run initdb
    with an argument other than &quot;/usr/local/var/postgres&quot;.
    $ mkdir -p ~/Library/LaunchAgents
    $ cp /usr/local/Cellar/postgresql/9.2.1/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
    $ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
    homebrew.mxcl.postgresql: Already loaded
    $ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
    server starting
    $ env ARCHFLAGS=&quot;-arch x86_64&quot; gem install pg
    Building native extensions.  This could take a while...
    Successfully installed pg-0.14.1
    1 gem installed
    $ psql --version
    psql (PostgreSQL) 9.2.1
    $ psql
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket &quot;/tmp/.s.PGSQL.5432&quot;?

&lt;!-- end snippet --&gt;

Now, after I reinstalled homebrew, when I use `$ psql`, it doesn&#39;t show any error message.

But I run `rake db:migrate` in my Rails app, it shows:


&lt;!-- begin snippet: js hide: true --&gt;

&lt;!-- language: lang-js --&gt;

    could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket &quot;/var/pgsql_socket/.s.PGSQL.5432&quot;?

    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1213:in `initialize&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1213:in `new&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1213:in `connect&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:329:in `initialize&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `new&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `postgresql_connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:309:in `new_connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:319:in `checkout_new_connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:241:in `block (2 levels) in checkout&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:236:in `loop&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:236:in `block in checkout&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:233:in `checkout&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:96:in `block in connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:95:in `connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:404:in `retrieve_connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_specification.rb:170:in `retrieve_connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_specification.rb:144:in `connection&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:107:in `rescue in create_database&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:51:in `create_database&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:40:in `block (3 levels) in &lt;top (required)&gt;&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:40:in `each&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:40:in `block (2 levels) in &lt;top (required)&gt;&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:205:in `call&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:205:in `block in execute&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:200:in `each&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:200:in `execute&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:158:in `block in invoke_with_call_chain&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:151:in `invoke_with_call_chain&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/task.rb:144:in `invoke&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:116:in `invoke_task&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:94:in `block (2 levels) in top_level&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:94:in `each&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:94:in `block in top_level&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:88:in `top_level&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:66:in `block in run&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling&#39;
    /usr/local/Cellar/ruby/1.9.3-p327/lib/ruby/1.9.1/rake/application.rb:63:in `run&#39;
    /usr/local/bin/rake:32:in `&lt;main&gt;&#39;
    Couldn&#39;t create database for {&quot;adapter&quot;=&gt;&quot;postgresql&quot;, &quot;encoding&quot;=&gt;&quot;unicode&quot;, &quot;database&quot;=&gt;&quot;riy_development&quot;, &quot;pool&quot;=&gt;5, &quot;username&quot;=&gt;nil, &quot;password&quot;=&gt;nil}

&lt;!-- end snippet --&gt;



**Finally I&#39;ve found a solution.**

&lt;!-- language: lang-sh --&gt;

    sudo mkdir /var/pgsql_socket/
    sudo ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

This solution is a little tricky, but it works. Hope anyone has a better solution

**Update**

This works for me as well.

&lt;!-- language: lang-sh --&gt;

    rm /usr/local/var/postgres/postmaster.pid




Postgres could not connect to server

If I have two relations in a database, like this:

    CREATE TABLE Courses (
      CourseID int NOT NULL PRIMARY KEY,
      Course VARCHAR(63) NOT NULL UNIQUE,
      Code CHAR(4) NOT NULL UNIQUE
    );

    CREATE TABLE BookCourses (
      EntryID int NOT NULL PRIMARY KEY,
      BookID int NOT NULL,
      Course CHAR(4) NOT NULL,
      CourseNum CHAR(3) NOT NULL,
      CourseSec CHAR(1) NOT NULL
    );

and I establish a foreign key relationship between the two, like this:

    ALTER TABLE BookCourses
    ADD FOREIGN KEY (Course)
    REFERENCES Courses(Code)
    ON DELETE CASCADE;

Then you can see that the `Course` attribute in the `BookCourses` relation references the `Code` attribute in the `Courses` relation.

My question is when a deletion occurs in either of the two relations, which way does the deletion cascade? If I delete a tuple in the `Courses` relation, will it delete all referencing tuples in the `BookCourses` relation, or is it the other way around?

SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?

I have a Postgres schema which looks like:

![enter image description here][1]

The problem is that whenever I save text longer than 500 characters in the description column I get the error:

    value too long for type character varying(500)

In the documentation for Postgres it says type text can have unlimited characters.

I&#39;m using postgresql-9.1.

This table has been generated using Django 1.4 and the field type in the model is TextField, if that helps explain the problem further.

Any ideas as why this is happening and what I can do to fix it?

  [1]: http://i.stack.imgur.com/wQ4l0.png

Strange PostgreSQL &quot;value too long for type character varying(500)&quot;

I&#39;m very much inspired by the approach to data management [advocated by Rich Hickey](http://www.infoq.com/author/Rich-Hickey), and implemented in [Datomic](http://www.datomic.com/), where the data is never mutated in-place, all the versions are _always_ preserved and query-able, and the time is a first-class concept.

Of course, there are specialized databases matching that description, like Git, or any other source control system. The question is if there are any (more or less) general-purpose DBMS-es of relational, graph, hierarchical, document or any other flavor that can be effectively used in, say, an eCommerce Web application. Or is Datomic the only choice then?

General-purpose databases that never delete or update data in-place

Why do I need Transaction in Hibernate for read-only operations?  

Does the following transaction put a lock in the DB? 

Example code to fetch from DB:

    Transaction tx = HibernateUtil.getCurrentSession().beginTransaction(); // why begin transaction?
    //readonly operation here
    
    tx.commit() // why tx.commit? I don&#39;t want to write anything

Can I use `session.close()`  instead of `tx.commit()`?

Why do I need Transaction in Hibernate for read-only operations?

I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and safely save HTML in the database.

Well, here are the main problems:

 1. I looked at &lt;http://php.net/manual/en/ref.pdo-mysql.php&gt;, and I don&#39;t really get where I should put that `$ ./configure --with-pdo-mysql` string...

 2. The site I&#39;m building actually only requires PDO for one page. While I may consider re-writing it, it would take a while and I need the pages to be running soon, so I can&#39;t turn off MySQL completely. If I do install PDO, will I still be able to use `mysql_*` handlers?

The server in question is running PHP Version 5.4.6-1ubuntu1 and Apache/2.2.22 (Ubuntu). I&#39;m also running a phpMyAdmin database, if it matters.



Installing PDO driver on MySQL Linux server

In my local development Ubuntu box I use MySQL and phpmyadmin to work with the database. 

Whenever phpmyadmin is idle for 1440 secs (24min) the session expires. I lose my place and have to login and start over.  

I tried changing the `$cfg[&#39;LoginCookieValidity&#39;] = 3600 * 9;` inside `config.inc.php` but it still times out in 1440 seconds.  

I have restarted everything and cleared the browser cache (Firefox history -&gt; Clear recent history -&gt; Cache -&gt; Everything).

I&#39;m not sure why the increased timeout does not take effect.  What am I doing wrong?

phpmyadmin logs out after 1440 secs

Does anyone know how to list every table (disable the pagination) in PhpMyAdmin&#39;s left menu? I have over 250 tables in my DB and now we are seeing the pageination. It&#39;s very annoying having to go back and forth and would be much easier to have them all listed.

We found the following variable:

    $cfg[&#39;LeftDisplayTableFilterMinimum&#39;]  = 30

However, when I put it into our config file it doesn&#39;t appear to have any affect.

In the [Documentation][1] it says to set it to a big number to disable, we tried that as well with no success.

Any help would be greatly appreciated! 

  [1]: http://wiki.phpmyadmin.net/pma/Config#Left_frame_setup

How to list all tables in PhpMyAdmin&#39;s left menu?

How do I change the MySQL root password and username in ubuntu server?  Do I need to stop the mysql service before setting any changes? 

I have a phpmyadmin setup as well, will phpmyadmin get updated automatically?

MySQL: How to reset or change the MySQL root password?

Assuming there is a remote server and I have phpMyAdmin client installed localy on my computer. How can I access this server and manage it via phpMyAdmin client? Is that possible? 

Content Type	Original Author	Original Content on Stackoverflow
Question	I wrestled a bear once.	View Question on Stackoverflow
Solution 1 - Php	Havelock	View Answer on Stackoverflow
Solution 2 - Php	codingbiz	View Answer on Stackoverflow

phpMyAdmin Duplicate Table

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

Python dynamic function creation with custom names

How to implement a FSM - Finite State Machine in Java

Attributions