Sponsored Content
Top Forums Shell Programming and Scripting how to break mysql dump sql file Post 302194982 by era on Wednesday 14th of May 2008 05:39:20 AM
Old 05-14-2008
man csplit
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

restore mysql dump file in many remote servers?

Hi all, I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not... (2 Replies)
Discussion started by: blesets
2 Replies

2. Shell Programming and Scripting

use SQL loader to dump a fixed length file in to DB

consider a fixed length file 12345abcd8901 12345abcd7777 12345njdu8888 12345hdku8388 i would like to dump it in to oracle DB using sql loader 12345 in to first coloumn abcd in to second coloumn 8901 in to 3rd coloumn (2 Replies)
Discussion started by: anumkoshy
2 Replies

3. Programming

accessing mysql from ms-sql

Hi, I was trying to access Mysql Server sitting in Linux Box from MS-SQL through linked server concept. I am getting the error as : "Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary... (0 Replies)
Discussion started by: DILEEP410
0 Replies

4. Web Development

Confused maybe about MySQL Dump & PHP

Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So... (12 Replies)
Discussion started by: jzacsh
12 Replies

5. Shell Programming and Scripting

Can't add variable to file name in mySQL dump script

I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work. I get the error: $SOURCEDIR/p1db_$DATEVAR.sql:... (3 Replies)
Discussion started by: ojobson
3 Replies

6. Programming

SQL for table with column (varchar2 2000) and line break in it

Hi, I need a sql statement for a table, which simply stores a text. It has a column ID, key1, key2, ..., text, date etc. The text can be entered using a line break (return) in an oracle form. ID key1 key2 text date 1 K1 ... (16 Replies)
Discussion started by: spidermike
16 Replies

7. Programming

[SQL] Insert content file to mysql

dear all, i want to insert string in file to mysql i just want how to do that cause i am poor in sql languages ... so this file like this DATA.txt doni|student|westjava|123412|lombok| iwan|student|westjava|1234412|utankayu| rio|student|westjava|12342|cempedak| so i want insert DATA.txt to... (2 Replies)
Discussion started by: zvtral
2 Replies

8. Shell Programming and Scripting

sql dump file - how to get certain values using sed

Hi, I have a dumpfile.sql - ========Start of file================= CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */; CREATE TABLE `test_table1` ( `id` int ) AUTO_INCREMENT=12 CREATE TABLE `test_table2` ( `id` int ) AUTO_INCREMENT=120... (5 Replies)
Discussion started by: ashokvpp
5 Replies

9. Shell Programming and Scripting

Links replacement on sql dump

Hi All I have dump of mysql DB (Joomla), and I found out that there is absolute links on the DB not with the domain name but the IP address ex: ,(115205,'http://54.5.17.148//index.php/restoflink... (12 Replies)
Discussion started by: molwiko
12 Replies
csplit(1)						      General Commands Manual							 csplit(1)

NAME
csplit - context split SYNOPSIS
prefix] number] file arg1 [...argn] DESCRIPTION
reads file, separates it into n+1 sections as defined by the arguments arg1 ... argn, and places the results in separate files. The maxi- mum number of arguments (arg1 through argn) allowed is 99 unless the option is used to allow for more output file names. If the option is specified, the resulting filenames are through prefixNN where NN is the two-digit value of n using a leading zero if n is less than 10. If the option is not specified, the default filenames through are used. file is divided as follows: Default Prefixed Filename Filename Contents ----------------------------------------------------- xx00 prefix00 From start of file up to (but not including) the line refer- enced by arg1. xx01 prefix01 From the line referenced by arg1 up to the line referenced by arg2. . . . xxNN prefixNN From the line referenced by argn to end of file. If the file argument is standard input is used. supports the Basic Regular Expression syntax (see regexp(5)). Options recognizes the following options: Suppress printing of all character counts normally prints the character counts for each file created). Leave previously created files intact normally removes created files if an error occurs). Name created files through prefixNN (default is through The output file name suffix will use number digits instead of the default This allows creation of more than 100 output files. Arguments (arg1 through argn) to can be any combination of the following: Create a file containing the section from the current line up to (but not including) the line matching the regular expression regexp. The new current line becomes the line matching regexp. Create a file containing the section from the current line up to (but not including) the nth before or after the line matching the regular expression regexp. (e.g., The new current line becomes the line matching plus or minus n lines. equivalent to except that no file is created for the section. line_number Create a file from the current line up to (but not including) line_number. The new current line becomes line_number. Repeat argument. This argument can follow any of the above argument forms. If it follows a regexp argument, that argument is applied num more times. If it follows line_number, the file is split every line_number lines for num times from that point until end-of-file is reached or num expires. Repeats previous operand as many times as necessary to finish input. Enclose in appropriate quotes all regexp arguments containing blanks or other characters meaningful to the shell. Regular expressions must not contain embedded new-lines. does not alter or remove the original file; it is the user's responsibility to remove it when appropriate. EXTERNAL INFLUENCES
Environment Variables determines the collating sequence used in evaluating regular expressions. determines the characters matched by character class expressions in regular expressions. determines the language in which messages are displayed. If or or is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty variable. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See environ(5). International Code Set Support Single- and multi-byte character code sets are supported. DIAGNOSTICS
Messages are self explanatory except for: which means that the given argument did not reference a line between the current position and the end of the file. This warning also occurs if the file is exhausted before the repeat count is. EXAMPLES
Create four files, through After editing the ``split'' files, recombine them back into the original file, destroying its previous contents. Perform editing operations Split a file at every 100 lines, up to 10,000 lines (100 files). The option causes the created files to be retained if there are fewer than 10,000 lines (an error message is still printed). Assuming that follows the normal C coding convention of terminating routines with a at the beginning of the line, create a file containing each separate C routine (up to 21) in SEE ALSO
sh(1), split(1), environ(5), lang(5), regexp(5). STANDARDS CONFORMANCE
csplit(1)
All times are GMT -4. The time now is 07:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy