In the MySQL interactive client you can type:

    source yourfile.sql

Alternatively you can pipe the data into mysql from the command line:

    mysql &lt; yourfile.sql

If the file doesn&#39;t specify a database then you will also need to add that:

    mysql db_name &lt; yourfile.sql

See the documentation for more details:

 * [Executing SQL Statements from a Text File][1]
[1]: https://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

If you have password for your dB then

    mysql -u &lt;username&gt; -p &lt;DBName&gt; &lt; yourfile.sql

I am experiencing issues with a WCF REST service. The wire object that I try to return has certain properties not set, resulting in DateTime.MinValue for properties of type DateTime. The service returns an empty document (with HTTP status 200 ???). When I try to call JSON serialization myself, the exception that is thrown is:
&gt; SerializationException: DateTime values that are greater than DateTime.MaxValue or smaller than DateTime.MinValue when converted to UTC cannot be serialized to JSON.

This can be reproduced by running the following code in a console app:

    DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(DateTime));
    MemoryStream m = new MemoryStream();
    DateTime dt = DateTime.MinValue;

    // throws SerializationException in my timezone
    ser.WriteObject(m, dt);
    string json = Encoding.ASCII.GetString(m.GetBuffer());
    Console.WriteLine(json);

Why is this behaviour? I think it is related to my timezone (GMT+1). As DateTime.MinValue is default(DateTime), I would expect that this can be serialized without problems.

Any tips on how to make my REST service behave? I don&#39;t want to change my DataContract.


Why can DateTime.MinValue not be serialized in timezones ahead of UTC?

I want to know how to create a simple desktop environment, such as KDE, Gnome and LXDE, for Linux, or specifically, Ubuntu/Kubuntu, but I do not know how to begin and how complex it is.

I want to create a simple, efficient and lightweight desktop and to reproduce some good features from KDE, Gnome and Windows XP. I do not want to reinvent the wheel, I want to design the graphical interface and main dialogs.

I could use C++ with Qt, or maybe with X11 calls. A simple desktop like TWM would be the first step, then I could add taskbar, start menu, new features and play with new ideas.

Thanks.


**Edit**

I have installed icewm and I think it is what I need to begin. On the login screen, I can choose if I use KDE (desktop environment) or icewm (window manager). I do not understand what a window manager actually is.

I have downloaded icewm source code and I am confused. There are some concepts that I have to understand, such as, what happens after the login screen when the desktop is loaded, how a window works, etc.


**Edit 2**

I think I need a good tutorial. I have to understand how a Window Manager or Desktop Environment work. There are some concepts that I have to know.


How to create a simple desktop environment?

I have a database that I created using the CREATE DATABASE statement in the terminal and I have a .sql file full of statements creating tables and rows.

I just wanted to know what was the command line to execute that .sql on the database I created?

Execute SQL script to create tables and rows

<p>I have a database that I created using the CREATE DATABASE statement in the terminal and I have a .sql file full of statements creating tables and rows.</p>
<p>I just wanted to know what was the command line to execute that .sql on the database I created?</p>


I have tables that I&#39;ve tried setting PK FK relationships on but I want to verify this. How can I show the PK/FK restraints? I saw [this][1] manual page, but it does not show examples and my google search was fruitless also. My database is `credentialing1` and my constrained tables are `practices` and `cred_insurances`.


  [1]: http://dev.mysql.com/doc/refman/5.5/en/table-constraints-table.html

Show constraints on tables command

Error
SQL query: 

    --
    -- Database: `work`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `administrators`
    --
    CREATE TABLE IF NOT EXISTS `administrators` (
    
    `user_id` varchar( 30 ) NOT NULL ,
    `password` varchar( 30 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;


MySQL said:  

    #1046 - No database selected

need some help here.




Error 1046 No database Selected, how to resolve?

I would like to have a mysql query like this:

    select &lt;second word in text&gt; word, count(*) from table group by word;

All the regex examples in mysql are used to query if the text matches the expression, but not to extract text out of an expression. Is there such a syntax?

How to extract the nth word and count word occurrences in a MySQL string?

I have two `*.sql` files that I use when creating a new web site database.  The first file creates all the tables.  The second file populates some default records.  I would like to execute these files from PHP.  I also use the Zend_Framework, if that will help accomplish this.

**Additional Info**

  1. I don&#39;t have console access
  1. I&#39;m trying to automate site generation from within our application.

**SOLUTION**

Using `shell_exec()`...

    $command = &#39;mysql&#39;
            . &#39; --host=&#39; . $vals[&#39;db_host&#39;]
            . &#39; --user=&#39; . $vals[&#39;db_user&#39;]
            . &#39; --password=&#39; . $vals[&#39;db_pass&#39;]
            . &#39; --database=&#39; . $vals[&#39;db_name&#39;]
            . &#39; --execute=&quot;SOURCE &#39; . $script_path
    ;
    $output1 = shell_exec($command . &#39;/site_db.sql&quot;&#39;);
    $output2 = shell_exec($command . &#39;/site_structure.sql&quot;&#39;);

...I never did get useful output, but followed [some suggestions][1] on [another thread][2] and finally got it all working.  I switch to the `--option=value` format for the commands and used `--execute=&quot;SOURCE ...&quot;` instead of `&lt;` to execute the file.

Also, I never got a good explanation of the difference between `shell_exec()` and `exec()`.


  [1]: https://stackoverflow.com/questions/814586/calling-mysql-exe-using-php-exec-doesnt-work/814722#814722
  [2]: https://stackoverflow.com/questions/814586/calling-mysql-exe-using-php-exec-doesnt-work

Running MySQL *.sql files in PHP

I have two indexed fields in a table - `type` and `userid` (individual indexes, not a composite). 

`type`s field values are very limited (let&#39;s say it is only 0 or 1), so 50% of table records have the same `type`. `userid` values, on the other hand, come from a much larger set, so the amount of records with the same `userid` is small.

Will any of these queries run faster than the other:

	select * from table where type=1 and userid=5
	select * from table where userid=5 and type=1

Also if both fields were not indexed, would it change the behavior?

Does the order of fields in a WHERE clause affect performance in MySQL?

What type of parameter/flag can I use with the Unix `find` command so that I search executables?



Search for executable files using find command

How can I increase the cursor speed in terminal?
I have Mac OS X by the way.
It would also be interesting to know it for Linux.

I don&#39;t know what I should search for in Google (or what you like).


How can I increase the cursor speed in terminal?

I want to copy all files in a directory except some files in a specific sub-directory.
I have noticed that `cp` command didn&#39;t have the `--exclude` option.
So, how can I achieve this?

How to use &#39;cp&#39; command to exclude a specific directory?

Some background info: I was looking to run a script on a Red Hat server to read some data from /dev/random and use the Perl unpack() command to convert it to a hex string for usage later on (benchmarking database operations).  I ran a few &quot;head -1&quot; on /dev/random and it seemed to be working out fine, but after calling it a few times, it would just kinda hang.  After a few minutes, it would finally output a small block of text, then finish.

I switched to /dev/urandom (I really didn&#39;t want to, its slower and I don&#39;t need that quality of randomness) and it worked fine for the first two or three calls, then it too began hang.
I was wondering if it was the &quot;head&quot; command that was bombing it, so I tried doing some simple I/O using Perl, and it too was hanging.
As a last ditch effort, I used the &quot;dd&quot; command to dump some info out of it directly to a file instead of to the terminal.  All I asked of it was 1mb of data, but it took 3 minutes to get ~400 bytes before I killed it.

I checked the process lists, CPU and memory were basically untouched.  What exactly could cause /dev/random to crap out like this and what can I do to prevent/fix it in the future?


*Edit:* Thanks for the help guys!  It seems that I had random and urandom mixed up.  I&#39;ve got the script up and running now.  Looks like I learned something new today. :)

/dev/random Extremely Slow?

On most terminals it is possible to colorize output using the `\033` ANSI escape sequence.

I&#39;m looking for a list of all supported colors and options (like bright and blinking).

As there are probably differences between the terminals supporting them, I&#39;m mainly interested in sequences supported by xterm-compatible terminals.

Content Type	Original Author	Original Content on Stackoverflow
Question	Johanisma	View Question on Stackoverflow
Solution 1 - Mysql	Mark Byers	View Answer on Stackoverflow
Solution 2 - Mysql	user88975	View Answer on Stackoverflow

Execute SQL script to create tables and rows

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

How to create a simple desktop environment?

Why can DateTime.MinValue not be serialized in timezones ahead of UTC?

Attributions