Am 04.11.2011 19:12, schrieb Ian Rubado:
> Hi there,
>
> I had the same issue as you posted about at the bottom of:
>
> http://bugs.mysql.com/bug.php?id=20867
>
> I was curious if you ever found a solution. I ended up converting tables to
> MyIsam and flushing my innodb files to resolve.
no,
Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat > ~/payload/scripts/create_mysqldb.sql << EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove anonym
You could try it inside a "here" document:
mysql < Date: Thu, 29 Jul 2010 14:29:55 -0500
> From: todd_...@ssiresults.com
> To: mysql@lists.mysql.com
> Subject: Variable Expansion Using MySQL Client and .sql Files
>
> Hey all,
>
> I've found many packag
Hey all,
I've found many packages that sit on top of MySQL for various clients.
For the purposes of consistency I'd like to automate these installs.
I've been directed towards using .sql files and they work great.
The trouble I'm having now is that I would like to secu
On Wednesday 01 April 2009 16:49, Eugene Kosov wrote:
> What about source?
>
>
> use foobar;
>
> source some/dir/file1.sql;
> source some/dir/file2.sql;
> ...
Gee... why did I not find that on google? :D
Thanks... this give me control of the order of the files, which can be
important.
--
Jørn
, Jørn Dahl-Stamnes
wrote:
Hello,
After googling for an hour I gave up to find a solution.
Problem: A framework is creating a lot of SQL files that will create the
database. But I'm tired of doing 10-20-30 'mysql -u... < file.sql' each
time I rebuild the model.
What I want to do
No include is possible, but this is done pretty routinely:
cat *.sql | mysql ...
- michael dykman
On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes
wrote:
> Hello,
>
> After googling for an hour I gave up to find a solution.
>
> Problem: A framework is creating a lot of SQL
Hello,
After googling for an hour I gave up to find a solution.
Problem: A framework is creating a lot of SQL files that will create the
database. But I'm tired of doing 10-20-30 'mysql -u... < file.sql' each
time I rebuild the model.
What I want to do is to create a s
I'm in the process of moving a MySQL database with about 170 tables from my PC
to a new MacBook Pro. On my PC, I exported each database table as a SQL file,
then copied a folder containing all these files to my Mac.
I'd like to know if there's a way to import all these SQL files
Hi,
In backup directory
cat *.sql | mysql -u root -p database
*
and
*Use import which is given below*
*
Dilipkumar wrote:
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key wa
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key was found, keep old row)*_
VenuGopal Papasani wrote:
hi all,
I have got a problem.I have data entered in different machines in
hi all,
I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in a same
database.Herethere was a problem in merging, There were some tables
which does´not change
th
?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Monday, July 19, 2004 8:52 AM
To: [EMAIL PROTECTED]
Subject: Re: #sql-... files
"Sergei Skarupo" <[EMAIL PROTECTED]> wrote:
> I see some files in the data dir with names like #sql-85d_4.MYI. Some of =
> the
"Sergei Skarupo" <[EMAIL PROTECTED]> wrote:
> I see some files in the data dir with names like #sql-85d_4.MYI. Some of =
> these are pretty old. Are these the temp tables that didn't get deleted =
> properly? Is it OK to shut down the server and delete them?
The answer is yes to both questions. :
Yes, these are normally temp files.
-Original Message-
From: Sergei Skarupo
To: [EMAIL PROTECTED]
Sent: 7/15/04 12:09 AM
Subject: #sql-... files
Greetings All,
I see some files in the data dir with names like #sql-85d_4.MYI. Some of
these are pretty old. Are these the temp tables that
Greetings All,
I see some files in the data dir with names like #sql-85d_4.MYI. Some of these are
pretty old. Are these the temp tables that didn't get deleted properly? Is it OK to
shut down the server and delete them?
Thanks,
Sergei
At 17:21 -0700 7/4/04, bruce wrote:
hi..
i can run sql files that have sql statements by :
shell:>mysql -u -p
is there a way to run foo.sql if i'm already inside the mysql env...
neither a search of google/mysql indicates that you can...
You don't have to use Google. Just read t
to clairfy
it looks as though the "source" function/command allows you to use the
script from inside the mysql env...
disreagrd
-bruce
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 5:22 PM
To: [EMAIL PROTECTED]
Subject: mysql
hi..
i can run sql files that have sql statements by :
shell:>mysql -u -p http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 22:17 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where
do exported SQL files go?:
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote:
At 20:13 -0700 on 06/02/2004, David Blomstrom wrote
about Re: Where
do exported SQL files go?:
>(I'm using Mozilla
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote:
> At 20:13 -0700 on 06/02/2004, David Blomstrom wrote
> about Re: Where
> do exported SQL files go?:
>
> >(I'm using Mozilla Firefox, which downloads
> >everything to the desktop, though I don'
12:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Where do exported SQL files go?
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote:
> At 20:13 -0700 on 06/02/2004, David Blomstrom wrote
> about Re: Where
> do exported SQL files go?:
>
> >(I'm using Mozilla Fi
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote:
> At 20:13 -0700 on 06/02/2004, David Blomstrom wrote
> about Re: Where
> do exported SQL files go?:
>
> >(I'm using Mozilla Firefox, which downloads
> >everything to the desktop, though I don'
At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where
do exported SQL files go?:
(I'm using Mozilla Firefox, which downloads
everything to the desktop, though I don't understand
why it considers this a download when it's a database
on my computer.)
Might it be do
--- Daniel Clark <[EMAIL PROTECTED]> wrote:
> Using phpmyadmin, when I select Export, and click
> the checkbox "Save as File", it prompts where for
> where and what file name.
Aha - you nailed it. I wasn't checking the "Save As"
box because the SQL box above was already checked. I
tried it again,
Using phpmyadmin, when I select Export, and click the checkbox "Save as File", it
prompts where for where and what file name.
>>I'm trying to figure out how to get my MySQL databases
>>online. Someone told me to EXPORT my databases as SQL
>>files, then go int
I'm trying to figure out how to get my MySQL databases
online. Someone told me to EXPORT my databases as SQL
files, then go into my online websites's phpMyAdmin
program and import it, and everything else would fall
into place.
At first, I was confused and exported just a single
table.
Hi:
Or you can use a DTS to transfer the info to MySQL
Greetings
From: "Ralph Guzman" <[EMAIL PROTECTED]>
To: "'Rudolf Bekker'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: Pulling large Microsoft SQL files into MySQL
Date: Tue, 15 Ju
IL PROTECTED]
Sent: Tuesday, July 15, 2003 2:43 AM
To: [EMAIL PROTECTED]
Subject: FW: Pulling large Microsoft SQL files into MySQL
Importance: High
-Original Message-
From: Rudolf Bekker
Sent: Monday, 14 July 2003 14:13
To: MySQL MailList ([EMAIL PROTECTED])
Subject: Pulling large Mi
-Original Message-
From: Rudolf Bekker
Sent: Monday, 14 July 2003 14:13
To: MySQL MailList ([EMAIL PROTECTED])
Subject: Pulling large Microsoft SQL files into MySQL
Importance: High
The MySQL manual mentions that one could specify the column and value separators and
the end of file
AIL PROTECTED]
Sent: Monday, July 14, 2003 5:13 AM
To: [EMAIL PROTECTED]
Subject: Pulling large Microsoft SQL files into MySQL
Importance: High
The MySQL manual mentions that one could specify the column and value
separators and the end of file marker explicitly in the LOAD DATA
statement.
I&
The MySQL manual mentions that one could specify the column and value separators and
the end of file marker explicitly in the LOAD DATA statement.
I'm looking for the syntax of this statement to import large data files (.txt)
originally exported from Microsoft SQL 7.
Example file:.
"Extra
> I have multiple SQL files that create different tables.
> Is there a way for me to create a single SQL file that will
> call these
> other files?
>
> Since I am using phpMyAdmin, I am assuming that call this file from
> phpMyAdmin?!
Since phpMyAdmin is a HTTP interfase
roject!
Cheers!
-warren
filter: queries, mysql, bigint
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "wcb" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 12:00 PM
Subject: Re: M
Warren,
Thank you for your prompt reply.
Actually, I have various ??.sql files that I can execute thru phpMyAdmin
and they all work, but on occasion, there is a need to run all the files at
once. So, I was wondering if I could create a file the would call these
other files and execute them in
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 11:39 AM
Subject: Multiple SQL files
> I have multiple SQL files that create different tables.
> Is there a way for me
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin
At 9:35 -0600 3/7/02, Paul DuBois wrote:
>At 12:06 +0200 3/7/02, Egor Egorov wrote:
>>Josiah,
>>Thursday, March 07, 2002, 8:18:58 AM, you wrote:
>>
>>JW> I know how to inport a .sql file into mysql by using mysql -u username -p
>>JW> password < filename.mysql(sql) but how do you import one that
>
At 12:06 +0200 3/7/02, Egor Egorov wrote:
>Josiah,
>Thursday, March 07, 2002, 8:18:58 AM, you wrote:
>
>JW> I know how to inport a .sql file into mysql by using mysql -u username -p
>JW> password < filename.mysql(sql) but how do you import one that is
>made to go
>JW> into a database you already
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW> I know how to inport a .sql file into mysql by using mysql -u username -p
JW> password < filename.mysql(sql) but how do you import one that is made to go
JW> into a database you already have created? Would the command by mysql -u
JW> us
On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote:
Would the command by mysql -u
> username -p password < dbname filename.sql(mysql)
>
No, just use
mysql dbname -uusername -ppaswwod < filename.sql
Regards
Georg
-
Be
I know how to inport a .sql file into mysql by using mysql -u username -p
password < filename.mysql(sql) but how do you import one that is made to go
into a database you already have created? Would the command by mysql -u
username -p password < dbname filename.sql(mysql)
Thanks,
Josiah Wallingfo
43 matches
Mail list logo