k.
Brian E Boothe wrote:
my database structure SQL dump
# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 14, 2006 at 12:36 AM
# Server version: 4.0.20
# PHP Version: 4.4.2
#
# Database : `workorder`
#
# ---
I guess that all depends on the nature of your "dump", doesn't it?
Database administrators call any transfer of data to a separate file a
"dump" and they come in all shapes and formats.
What can you tell us about the file you received?
Where did the data come from (what database system)?
What
Hello,
I am new to mySQL. Someone gave me a "dump" file and i need to do an
import from linux. How can i go about doing this can someone help me?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I make a huge sql dump to mysql client
ie :
mysql < dump.sql
the dump.sql is nearly 650 MB.
I get some strange file near my table files :
12 -rw-rw1 mysqlmysql8678 mar 28 22:26
/var/lib/mysql/doz/#sql-9a8_17.frm
63428 -rw-rw1 mysqlmy
PLEASE read the manual before posting.
Have you tried mysqldump? Should be in the same directory as the other mysql
binaries. /usr/local/mysql/bin on my machine, your machine may vary.
j- k-
On Monday 03 December 2001 14:33, Jonathan Hilgeman wrote:
> Just wondering if there's a bui
Just wondering if there's a built-in or distribution utility that comes with
MySQL (like mysqlhotcopy) that will output a file with SQL commands to
recreate a database. phpMyAdmin has a tool for doing this but I don't know
if there's something else built-in already that has that functionality.
-
t;
Sent: Saturday, October 27, 2001 6:36 PM
Subject: Re: Problem with huge sql-dump
>
> Are the statements ended properly?
>
> like...insert into table (values etc);
>
> Some db's will dump with no semicolon on the end...will give you
> an error on the second line.
>
;s a problem saying "Table already exists" then you will
either need to drop all the tables in that database, or re-generate the
query, enabling "drop table" statements.
Mike
Johan Nagels wrote:
>Hi,
>
>I'm trying to import a huge SQL-dump (generated by ano
Are the statements ended properly?
like...insert into table (values etc);
Some db's will dump with no semicolon on the end...will give you
an error on the second line.
eejack
091120010850
At 06:28 PM 10/27/01 +0200, Johan Nagels wrote:
>Hi,
>
>I'm trying to imp
Hi,
I'm trying to import a huge SQL-dump (generated by another program). The
statements are correct because if I excute them one-by-one no error is
generated. However if I upload them all at once (thru phpMyAdmi or Free
Mascon) I always get an error somewhere at te second line.
Btw. in the
10 matches
Mail list logo
