List:General Discussion« Previous MessageNext Message »
From:René Fournier Date:March 11 2009 2:16am
Subject:Re: mysqlimport remote host problem
View as plain text  
OK, I've managed to do the same thing with just the mysql command line  
program:

	mysql -h 192.168.0.224 -u root -p alba2 < /Backup/Latest/ 
alba2_2009-03-10_00h45m.Tuesday.sql

Works great. However, the sql file is normally gzipped, so.... Can I  
ungzip the file on the fly (and without removing the .gzip version)  
and pipe the contents as I did above? (Yes, I'm UNIX-impaired.)   
Something like:

	mysql -h 192.168.0.224 -u root -p alba2 < gzip -dc /Backup/Latest/ 
alba2_2009-03-10_00h45m.Tuesday.sql.gz

But so that it works...

...Rene

On 10-Mar-09, at 7:38 PM, René Fournier wrote:

> I'm writing script that, each night, copies a small database to my  
> laptop on the local network. I'm having trouble getting it to work.  
> Here's my syntax so far (run on the server):
>
> mysqlimport --host=192.168.0.224 --user=root --password alba2  
> alba2_2009-03-10_00h45m.Tuesday.sql
>
> Which produces:
>
> ---
> mysqlimport: Error: 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 '-03-10_00h45m IGNORE 0 LINES' at line 1, when  
> using table: alba2_2009-03-10_00h45m
> ---
>
> The sql file is produced by automysqlbackup...  Not sure what I'm  
> missing, probably something obvious. Anyway, here's the first part  
> of the sql file I want to import:
>
> -- MySQL Administrator dump 1.4
> --
> -- ------------------------------------------------------
> -- Server version	5.0.67-log
>
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
>
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,  
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,  
> SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
>
>
> --
> -- Create schema alba2
> --
>
> CREATE DATABASE IF NOT EXISTS alba2;
> USE alba2;
>
> --
> -- Definition of table `alba2`.`accounts`
> --
>
> DROP TABLE IF EXISTS `alba2`.`accounts`;
> CREATE TABLE  `alba2`.`accounts` (
>  `id` smallint(5) unsigned NOT NULL auto_increment,
>  `fp` varchar(40) NOT NULL,
>  `created` int(10) unsigned NOT NULL default '0',
>  `status` enum('Active','Inactive') NOT NULL default 'Active',
>  `account_name` varchar(40) NOT NULL,
>  `account_full_name` varchar(40) NOT NULL,
>  `address` varchar(40) NOT NULL,
>  `city` varchar(40) NOT NULL,
>  `province` varchar(10) NOT NULL,
>  `postcode` varchar(10) NOT NULL,
>  UNIQUE KEY `id` (`id`)
> ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
>
> --
> -- Dumping data for table `alba2`.`accounts`
> --
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

Thread
mysqlimport remote host problemRené Fournier11 Mar
  • Re: mysqlimport remote host problemRené Fournier11 Mar
    • Re: mysqlimport remote host problemDarryle Steplight11 Mar
      • Re: mysqlimport remote host problemwultsch11 Mar
    • Re: mysqlimport remote host problemRob Wultsch11 Mar
      • Re: mysqlimport remote host problemClaudio Nanni11 Mar
      • Re: mysqlimport remote host problemRené Fournier11 Mar