Use the `--force` (`-f`) flag on your mysql import.  Rather than stopping on the offending statement, MySQL will continue and just log the errors to the console.
  
For example:

    mysql -u userName -p -f -D dbName &lt; script.sql

I am trying to make software install to a specific directory. I found several ways, but not sure what are the differences between them.

1. `./configure --prefix=***`
3. `make install DESTDIR=***`
4. `make install prefix=***`

I am confused about the functions of these three. Do they achieve the same goal?

DESTDIR and PREFIX of make

I have a `UIViewController` view as a subview/modal on top of another `UIViewController` view, such as that the subview/modal should be transparent and whatever components is added to the subview should be visible. The problem is that I have is the subview shows black background instead to have clearColor. I&#39;m trying to make `UIView` as a clearColor not black background. Does anybody know what is wrong with it? Any suggestion appreciated.

**FirstViewController.m**

    UIStoryboard *storyboard = [UIStoryboard storyboardWithName:@&quot;MainStoryboard&quot; bundle:nil];
    UIViewController *vc = [storyboard instantiateViewControllerWithIdentifier:@&quot;SecondViewController&quot;];

    [vc setModalPresentationStyle:UIModalPresentationFullScreen];
    [self presentModalViewController:vc animated:NO];  

**SecondViewController.m**

    - (void)viewDidLoad 
    {
         [super viewDidLoad];
         self.view.opaque = YES;
         self.view.backgroundColor = [UIColor clearColor];
    }

----------

**RESOLVED**: I fixed the issues. It is working so well for both of iPhone and iPad. Modal View Controller with no black background just clearColor/transparent. The only thing that I need to change is I replaced `UIModalPresentationFullScreen` to `UIModalPresentationCurrentContext`. How simple is that!

**FirstViewController.m**

    UIStoryboard *storyboard = [UIStoryboard storyboardWithName:@&quot;MainStoryboard&quot; bundle:nil];
    UIViewController *vc = [storyboard instantiateViewControllerWithIdentifier:@&quot;SecondViewController&quot;];
    vc.view.backgroundColor = [UIColor clearColor];
    self.modalPresentationStyle = UIModalPresentationCurrentContext;
    [self presentViewController:vc animated:NO completion:nil];

------------------
**NOTICE:** If you are using a `modalPresentationStyle` property of `navigationController`:

**FirstViewController.m**

    UIStoryboard *storyboard = [UIStoryboard storyboardWithName:@&quot;MainStoryboard&quot; bundle:nil];
    UIViewController *vc = [storyboard instantiateViewControllerWithIdentifier:@&quot;SecondViewController&quot;];
    vc.view.backgroundColor = [UIColor clearColor];
    self.navigationController.modalPresentationStyle = UIModalPresentationCurrentContext;
    [self presentViewController:vc animated:NO completion:nil];

------------------
**NOTICE: The bad news is that the above solution doesn&#39;t work on iOS 7. The good news is that I fixed the issue for iOS7! I asked somebody for help and here is what he said:**

*When presenting a view controller modally, iOS removes the view controllers underneath it from the view hierarchy for the duration it is presented.  While the view of your modally presented view controller is transparent, there is nothing underneath it except the app window, which is black.  iOS 7 introduced a new modal presentation style, `UIModalPresentationCustom`, that causes iOS not to remove the views underneath the presented view controller. However, in order to use this modal presentation style, you must provide your own transition delegate to handle the presentation and dismiss animations.  This is outlined in the &#39;Custom Transitions Using View Controllers&#39; talk from WWDC 2013 &lt;https://developer.apple.com/wwdc/videos/?id=218&gt; which also covers how to implement your own transition delegate.* 

You may see my solution for the above issue in iOS7: https://github.com/hightech/iOS-7-Custom-ModalViewController-Transitions

Display clearColor UIViewController over UIViewController

I am importing a fairly large database. The `.sql` file has almost 1,000,000 lines in it. Problem is that I am getting a syntax error when trying to import the database. It says: 

&gt; ERROR 1064 (42000) at line 8428420: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;&lt;br /&gt;
&lt;b&gt;Fatal error&lt;/b&gt;:  Maximum execution time of 600 seconds exceeded in &lt;b&#39; at line 194

Normally I&#39;d just open the .sql file and fix the error. But my computer is really struggling to open this file. 

Is there any way I can ignore errors when importing a MySQL database?

MySQL: ignore errors when importing?

I am importing a fairly large database. The <code>.sql</code> file has almost 1,000,000 lines in it. Problem is that I am getting a syntax error when trying to import the database. It says:
> ERROR 1064 (42000) at line 8428420: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
Fatal error: Maximum execution time of 600 seconds exceeded in <b' at="" line="" 194&#x3C;="" p="">
</b'>Normally I'd just open the .sql file and fix the error. But my computer is really struggling to open this file.
Is there any way I can ignore errors when importing a MySQL database?

How can I change the phpmyadmin automatic log out time?

It will log out automatically after 1440 seconds which is very low for me.  How can I change the option or remove log in request completely?

phpmyadmin automatic logout time

How can I measure the execution time of a query without measuring the time it spends waiting for a lock release etc? My only idea was to continuously measure same query and record the fastest time. 

Measuring actual MySQL query time

I know that this line of code will make the cell text-wrap:

    $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle(&#39;D1&#39;)-&gt;getAlignment()-&gt;setWrapText(true);
&#39;D1&#39; being the chosen cell.

Instead of using this code for every cell I need wrapped, is there a way to make the entire Excel Worksheet automatically wrap everything?

Or is there a better practice technique to use for specified columns? 

PHPExcel and Text Wrapping

I want to import a sql file of approx 12 mb. But its causing problem while loading. Is there any way to upload it without splitting the sql file ?

How to import large sql file in phpmyadmin

I got the following error while trying to alter a column&#39;s data type and setting a new default value:

    ALTER TABLE foobar_data ALTER COLUMN col VARCHAR(255) NOT NULL SET DEFAULT &#39;{}&#39;;

&gt; ERROR 1064 (42000): You have an error in your SQL syntax; check the
&gt; manual that corresponds to your MySQL server version for the right
&gt; syntax to use near &#39;VARCHAR(255) NOT NULL SET DEFAULT &#39;{}&#39;&#39; at line 1

How to alter a column and change the default value?

I&#39;d like to be able to save the current canvas&#39; state to a server-side database, probably as a JSON string, and then later restore it with `loadFromJSON`. Typically, this is easily accomplished using:

    var canvas = new fabric.Canvas();
	function saveCanvas() {
		// convert canvas to a json string
		var json = JSON.stringify( canvas.toJSON() );

		// save via xhr
		$.post(&#39;/save&#39;, { json : json }, function(resp){ 
			// do whatever ...
		}, &#39;json&#39;);
	}

And then 

    function loadCanvas(json) {

      // parse the data into the canvas
      canvas.loadFromJSON(json);

      // re-render the canvas
      canvas.renderAll();

      // optional
      canvas.calculateOffset();
    }

However, I&#39;ve also been setting a few custom attributes on the fabric objects I&#39;m adding to the canvas using the builtin `Object#set` method:

	// get some item from the canvas
	var item = canvas.item(0);

	// add misc properties
	item.set(&#39;wizard&#39;, &#39;gandalf&#39;);
	item.set(&#39;hobbit&#39;, &#39;samwise&#39;);

	// save current state
	saveCanvas();

The problem is that when I check the request on the server-side, I see that my custom attributes were not parsed from the canvas and sent along with everything else. This probably has to do with how `toObject` method removes anything that&#39;s not a default attribute in the object class. What would be a good way to tackle this issue, such that I&#39;ll be able to both save **and** restore the canvas from a JSON string sent by the server, and the restored canvas will also include my custom attributes? thanks.


Fabric.js - how to save canvas on server with custom attributes

I just installed **SQL Server 2012 Express**, I can connect with database from **`VS2012RC`**. 

Database is working :) I use **`Win7 SP1 64bit`**.

**[I download program from page](http://www.microsoft.com/en-us/download/details.aspx?id=29062)**
I choose `ENU\x64\SQLManagementStudio_x64_ENU.exe`

I want to install **Management Studio 2012**, but after unpack installer has stopped. I see only for moment some console application. 

1. What could be cause? 
2. Where can I find any log file?

How to install SQL Server Management Studio 2012 (SSMS) Express?

Everywhere I look, I see that MongoDB is CP.
But when I dig in I see it is eventually consistent.
Is it CP when you use safe=true? If so, does that mean that when I write with safe=true, all replicas will be updated before getting the result?

Where does mongodb stand in the CAP theorem?

I have a CSV file. It contain 1.4 million rows of data, so I am not able to open that csv file in Excel because its limit is about 1 million rows. 

Therefore, I want to import this file in MySQL workbench. This csv file contains columns like 

    &quot;Service Area Code&quot;,&quot;Phone Numbers&quot;,&quot;Preferences&quot;,&quot;Opstype&quot;,&quot;Phone Type&quot;

I am trying to create a table in MySQL workbench named as &quot;dummy&quot; containing columns like 

    ServiceAreaCodes,PhoneNumbers,Preferences,Opstyp,PhoneTyp. 

The CSV file is named `model.csv`. My code in workbench is like this:

    LOAD DATA LOCAL INFILE &#39;model.csv&#39; INTO TABLE test.dummy FIELDS TERMINATED BY &#39;,&#39; lines terminated by &#39;\n&#39;;

but I am getting an error like `model.CSV file not found`

How to import a csv file into MySQL workbench?

Apologies in advance for the simplicity of this question. I am trying to import a .dat file from a website into R with the following code:

    www = &quot;http://www.nilu.no/projects/ccc/onlinedata/ozone/CZ03_2009.dat&quot;
    data &lt;- read.delim(www, header = TRUE, sep=&quot;\t&quot;) 

I want to access the Value portion of the data.frame, however, I am unsure about the dimensions of the data.frame, if I type ncol(data) it returns 1 which I was expecting three. How do I access the &quot;third&quot; column of this data.frame? 

import dat file into R

I&#39;m using python2.6 and got a problem this morning. It said &#39;module&#39; has no attribute &#39;Image&#39;. Here is my input. Why the first time I can not use PIL.Image?

    &gt;&gt;&gt; import PIL
    &gt;&gt;&gt; PIL.Image
    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    AttributeError: &#39;module&#39; object has no attribute &#39;Image&#39;
    &gt;&gt;&gt; from PIL import Image
    &gt;&gt;&gt; Image
    &lt;module &#39;PIL.Image&#39; from &#39;/usr/lib/python2.6/dist-packages/PIL/Image.pyc&#39;&gt;
    &gt;&gt;&gt; PIL.Image
    &lt;module &#39;PIL.Image&#39; from &#39;/usr/lib/python2.6/dist-packages/PIL/Image.pyc&#39;&gt;



Python PIL has no attribute &#39;Image&#39;

I fear that this is a messy way to approach the problem but... 

let&#39;s say that I want to make some imports in Python based on some conditions.

For this reason I want to write a function:

    def conditional_import_modules(test):
        if test == &#39;foo&#39;:
            import onemodule, anothermodule
        elif test == &#39;bar&#39;:
            import thirdmodule, and_another_module
        else:
            import all_the_other_modules

Now how can I have the imported modules globally available?

For example:

    conditional_import_modules(test=&#39;bar&#39;)
    thirdmodule.myfunction()



How to make global imports from a function?

Having already use flat packages, I was not expecting the issue I encountered with nested packages. Here is…


# Directory layout

    dir
     |
     +-- test.py
     |
     +-- package
          |
          +-- __init__.py
          |
          +-- subpackage
               |
               +-- __init__.py
               |
               +-- module.py

# Content of __init__.py

Both `package/__init__.py` and `package/subpackage/__init__.py` are empty.

# Content of `module.py`

    # file `package/subpackage/module.py`
    attribute1 = &quot;value 1&quot;
    attribute2 = &quot;value 2&quot;
    attribute3 = &quot;value 3&quot;
    # and as many more as you want...

# Content of `test.py` (3 versions)

## Version 1

    # file test.py
    from package.subpackage.module import *
    print attribute1 # OK

That&#39;s the bad and unsafe way of importing things (import all in a bulk), but it works.

## Version 2

    # file test.py
    import package.subpackage.module
    from package.subpackage import module # Alternative
    from module import attribute1

A safer way to import, item by item, but it fails, Python don&#39;t want this: fails with the message: &quot;No module named module&quot;. However&#160;…

    # file test.py
    import package.subpackage.module
    from package.subpackage import module # Alternative
    print module # Surprise here

…&#160;says `&lt;module &#39;package.subpackage.module&#39; from &#39;...&#39;&gt;`. So that&#39;s a module, but that&#39;s not a module /-P 8-O ... uh

## Version 3

    # file test.py v3
    from package.subpackage.module import attribute1
    print attribute1 # OK

This one works. So you are either forced to use the overkill prefix all the time or use the unsafe way as in version #1 and disallowed by Python to use the safe handy way? The better way, which is safe and avoid unecessary long prefix is the only one which Python reject? Is this because it loves `import *` or because it loves overlong prefixes (which does not help to enforce this practice)?.

Sorry for the hard words, but that&#39;s two days I trying to work around this stupid‑like behavior. Unless I was totally wrong somewhere, this will leave me with a feeling something is really broken in Python&#39;s model of package and sub‑packages.

Notes 

 * I don&#39;t want to rely on `sys.path`, to avoid global side effects, nor on `*.pth` files, which are just another way to play with `sys.path` with the same global effets. For the solution to be clean, it has to be local only. Either Python is able to handle subpackage, either it&#39;s not, but it should not require to play with global configuration to be able to handle local stuff.
 * I also tried use imports in `package/subpackage/__init__.py`, but it solved nothing, it do the same, and complains `subpackage` is not a known module, while `print subpackage` says it&#39;s a module (weird behavior, again).

May be I&#39;m entirely wrong tough (the option I would prefer), but this make me feel a lot disappointed about Python.

Any other known way beside of the three I tried? Something I don&#39;t know about?

(sigh)


----- %&lt; ----- edit ----- &gt;% -----

# Conclusion so far (after people&#39;s comments)

There is nothing like real sub‑package in Python, as all package references goes to a global dictionnary, only, which means there&#39;s no local dictionary, which implies there&#39;s is no way to manage local package reference.

You have to either use full prefix or short prefix or alias. As in:

## Full prefix version

    from package.subpackage.module import attribute1
    # An repeat it again an again
    # But after that, you can simply:
    use_of (attribute1)

## Short prefix version (but repeated prefix)

    from package.subpackage import module
    # Short but then you have to do:
    use_of (module.attribute1)
    # and repeat the prefix at every use place

Or else, a variation of the above.

    from package.subpackage import module as m
    use_of (m.attribute1)
    # `m` is a shorter prefix, but you could as well
    # define a more meaningful name after the context

# Factorized version

If you don&#39;t mind about importing multiple entity all at once in a batch, you can:

    from package.subpackage.module import attribute1, attribute2
    # and etc.

Not in my first favorite taste (I prefer to have one import statement per imported entity), but may be the one I will personally favor.

_Update (2012-09-14):_

Finally appears to be OK in practice, except with a comment about the layout. Instead of the above, I used:

    from package.subpackage.module import (

        attribute1, 
        attribute2,
        attribute3,
        ...)  # and etc.


Content Type	Original Author	Original Content on Stackoverflow
Question	Dustin	View Question on Stackoverflow
Solution 1 - Mysql	Craig Boobar	View Answer on Stackoverflow

MySQL: ignore errors when importing?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Display clearColor UIViewController over UIViewController

DESTDIR and PREFIX of make

Attributions