Thanks, i wondered while i was in bed do i really need to create a smaller version of the database on the development server before i upload or would it be better to just dump remotely from the live server. i want the upload to be smooth to reduce any downtime when i do the upload. So i came up with this (ignore the drop database i will change it when i reverse engineer your script)
If you see i added the tables to the dump like suggested. I will try to remove the dropping database from root now
---------- Post updated at 02:40 AM ---------- Previous update was at 01:33 AM ----------
Ok i get what your script does and have altered my script to drop the tables i want to drop rather than using show tables and dropping them all
Does that seem alright?
Last edited by timgolding; 12-12-2012 at 05:48 AM..
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
OS: Linux ambglx02 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux
Shell: bash
Currently I have a mysqldump script to backup my mysql database, the command is as below:
/opt/novell/mysql/bin/mysqldump --add-drop-table -u root -p -h mydb > /home/john/mydb.sql
... (5 Replies)
hi,
I need to backup a database but I'm getting the error "bus error - core dumped" just after I run mysqldump command.
The server has installed solaris 9.
Any help would be appreciated (3 Replies)
Hi All,
I have a data calculation process-a perl script running each and every hour which will do some calculations on the data stored in a mysql server. Normally it tooks around 2minutes (max) to complete.
But in case if i did any actions on the linux box where the database is... (7 Replies)
I want to take a backup of a database and redirect the output of the whole process to a log file. I am using the below command:
mysqldump -A --add-drop-table > mysql-daily-backup.sql &> /tmp/backup_log/mysql.log
Is there anything wrong with the syntax?
---------- Post updated at 08:32 PM... (0 Replies)
My crontab file tells cron to run a certain shell script at 10:30 AM every day. The shell script backs up my database with mysqldump and then runs a sed script that does some editing of the backup file.
I have programmed the shell script to write an error message to a file I have in my home... (1 Reply)
I have a very simple script that uses a cron job to take a daily backup of our orders database.
echo "Dumping ORDERS database";
mysqldump -u root --password='mypassword' -h '1.1.1.1' --opt --compress ORDERS $tbl_names > /Volumes/Files_Backup_1/db_backups/orders.sql
echo "Copied database to... (2 Replies)
Hi @ all
I need a little bit help with a tricky problem ...
Here´s the situation:
We´ve 2 MySQL-Servers, one is productive, the other is Backup.
At the productive Server there runs every 2 hours a cron Job which does a Dump from MySQL-DB with script 'automysqlbackup.sh' and
copy it then... (7 Replies)
Discussion started by: jackcracker
7 Replies
LEARN ABOUT DEBIAN
freebsd-yyfix
YYFIX(1) BSD General Commands Manual YYFIX(1)NAME
yyfix -- extract tables from y.tab.c
SYNOPSIS
yyfix file [tables]
DESCRIPTION
Programs have historically used a script (often named ``:yyfix'') to extract tables from the yacc(1) generated file y.tab.c. As the names of
the tables generated by the current version of yacc(1) are different from those of historical versions of yacc(1), the shell script yyfix is
provided to simplify the transition.
The first (and required) argument to yyfix is the name of the file where the extracted tables should be stored.
If further command line arguments are specified, they are taken as the list of tables to be extracted. Otherwise, yyfix attempts to deter-
mine if the y.tab.c file is from an old or new yacc(1), and extracts the appropriate tables.
The tables ``yyexca'', ``yyact'', ``yypact'', ``yypgo'', ``yyr1'', ``yyr2'', ``yychk'', and ``yydef'' are extracted from historical versions
of yacc(1).
The tables ``yylhs'', ``yylen'', ``yydefred'', ``yydgoto'', ``yysindex'', ``yyrindex'', ``yygindex'', ``yytable'', ``yyname'', ``yyrule'',
and ``yycheck'', are extracted from the current version of yacc(1).
FILES
y.tab.c File from which tables are extracted.
SEE ALSO yacc(1)HISTORY
The yyfix command first appeared in 4.4BSD.
BSD March 23, 1993 BSD