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`
#
#
#
# Table
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]
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
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 mysqlmysql64880640
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.
-
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
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 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.
eejack
091120010850
At 06:28 PM 10/27/01 +0200, Johan Nagels wrote:
Hi,
I'm trying to import a huge SQL-dump (generated
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 another program). The
statements are correct because if I excute them one-by-one no error is
generated. However
, 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.
eejack
091120010850
At 06:28 PM 10/27/01 +0200, Johan
10 matches
Mail list logo