Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql::diff::database(3pm) [debian man page]

MySQL::Diff::Database(3pm)				User Contributed Perl Documentation				MySQL::Diff::Database(3pm)

NAME
MySQL::Diff::Database - Database Definition Class SYNOPSIS
use MySQL::Diff::Database; my $db = MySQL::Diff::Database->new(%options); my $source = $db->source_type(); my $summary = $db->summary(); my $name = $db->name(); my @tables = $db->tables(); my $table_def = $db->table_by_name($table); my @dbs = MySQL::Diff::Database::available_dbs(); DESCRIPTION
Parses a database definition into component parts. METHODS
Constructor new( %options ) Instantiate the objects, providing the command line options for database access and process requirements. Public Methods o source_type() Returns 'file' if the data source is a text file, and 'db' if connected directly to a database. o summary() Provides a summary of the database. o name() Returns the name of the database. o tables() Returns a list of tables for the current database. o table_by_name( $name ) Returns the table definition (see MySQL::Diff::Table) for the given table. FUNCTIONS
Public Functions o available_dbs() Returns a list of the available databases. Note that is used as a function call, not a method call. COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils AUTHOR
Adam Spiers <mysqldiff@adamspiers.org> perl v5.14.2 2012-04-06 MySQL::Diff::Database(3pm)

Check Out this Related Man Page

Algorithm::Diff::XS(3pm)				User Contributed Perl Documentation				  Algorithm::Diff::XS(3pm)

NAME
Algorithm::Diff::XS - Algorithm::Diff with XS core loop SYNOPSIS
# Drop-in replacement to Algorithm::Diff, but "compact_diff" # and C<LCSidx> will run much faster for large data sets. use Algorithm::Diff::XS qw( compact_diff LCSidx ); DESCRIPTION
This module is a simple re-packaging of Joe Schaefer's excellent but not very well-known Algorithm::LCS with a drop-in interface that simply re-uses the installed version of the Algorithm::Diff module. Note that only the "LCSidx" function is optimized in XS at the moment, which means only "compact_diff" will get significantly faster for large data sets, while "diff" and "sdiff" will run in identical speed as "Algorithm::Diff". BENCHMARK
Rate Algorithm::Diff Algorithm::Diff::XS Algorithm::Diff 14.7/s -- -98% Algorithm::Diff::XS 806/s 5402% -- The benchmarking script is as below: my @data = ([qw/a b d/ x 50], [qw/b a d c/ x 50]); cmpthese( 500, { 'Algorithm::Diff' => sub { Algorithm::Diff::compact_diff(@data) }, 'Algorithm::Diff::XS' => sub { Algorithm::Diff::XS::compact_diff(@data) }, }); SEE ALSO
Algorithm::Diff, Algorithm::LCS. AUTHORS
Audrey Tang <cpan@audreyt.org> COPYRIGHT
Copyright 2008 by Audrey Tang <cpan@audreyt.org>. Contains derived code copyrighted 2003 by Joe Schaefer, <joe+cpan@sunstarsys.com>. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2008-10-24 Algorithm::Diff::XS(3pm)
Man Page

13 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Something went awfully wrong in PHP+MySQL :(

When I'm running a few statements through mysql console, they are working just fine but when I'm trying to write some logic in php and trying to execute it, its awfully slow.. Its perhaps performing, 10 queries in 20 seconds... :( Why is this happening? My table structures are: Name:... (23 Replies)
Discussion started by: Legend986
23 Replies

2. UNIX for Dummies Questions & Answers

Question about excutable software in Unix

I am using SCO OpenServer 5.0 now, and have the old software as database (similar with MySQL) to store all data. I want to know that how can I read those data in the file. For example, I have file named OE.USECD, which is data file when I use the software to store my data to database. it's not... (5 Replies)
Discussion started by: wendyz
5 Replies

3. Web Development

Unkown table Engine 'InnoDB' on a RedHat server with MySQL v5!

hi all, After installing MySQL Source Code on my RedHat machine and compiling it, i no longer have access to some of my DBs having this error message. Unkown table Engine 'InnoDB' Before this step, i used to have another MySQL instance that used to work properly with all the DBs i do have,... (7 Replies)
Discussion started by: mehdi1973
7 Replies

4. Homework & Coursework Questions

C/C++ program that connects to a MySQLserver

Hi Programming Geeks, I got an interesting C++ and MySQL problem to solve. I was unable to do this as I am not much confident on MySQL DB. Please have a go at it if possible. Write a C/C++ program that connects to a MySQLserver and checks if the InnoDB plug-in is installed on it. If so,... (5 Replies)
Discussion started by: vivek.goel.piet
5 Replies

5. Web Development

Ideas for site migration: How would you do it? LAMP -> something w/ Sql Server

I'm afraid I'm going to have to migrate our entire website from Linux. There have been a number of irregularities in our MySQL database and the system that we have set up -probably isn't scalable. Since my manager is re-envisioning (taking the moment to re-engineer) -he wants to move the... (5 Replies)
Discussion started by: Astrocloud
5 Replies

6. Programming

MySQL join four tables!

Hello; I want merge four MySQL tables to get the intersection that have a common field for all of them. Join two tables is fine to me, but my this case is different from common situations and there are not very many discussions about it. Can anybody give me some idea? Thanks a lot! Here is part... (8 Replies)
Discussion started by: yifangt
8 Replies

7. Shell Programming and Scripting

Database is down

How to find out whether your database is down or not? Could anyone provide me the command please.. Thanks C (6 Replies)
Discussion started by: bobby1015
6 Replies

8. Shell Programming and Scripting

Mask the Oracle Database Data

Hi, We have to mask the data that is coming from production environment to Non-production environment. The database is running in oracle platform. If anybody has generic scripts to achive this task,it would be great if that can be shared with me? Thank you, Jayaprakash. (10 Replies)
Discussion started by: bandaru_0810
10 Replies

9. UNIX for Dummies Questions & Answers

Mysqldump certain tables

Hi, I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
Discussion started by: timgolding
5 Replies

10. Shell Programming and Scripting

Diff between two time in hours in last column

Dear All I want to diff between two time(FIRST 4 COLUMN) in hours in last column. Kindly help me for same. 2013-11-23 15:51:23 2013-11-23 12:20:06 BRC023 CG 2013-11-23 15:51:23 2013-11-23 12:20:08 BRC064CG 2013-11-23 15:51:23 2013-11-22 13:17:49 BLM003 NG 2013-11-23 15:51:23 2013-11-22... (9 Replies)
Discussion started by: jaydeep_sadaria
9 Replies

11. UNIX for Advanced & Expert Users

Small database that can be bundled with UNIX

Hi All, I am working on a file transfer tool between unix servers. for this i am looking for a small database which is free and compatible with all unix OS and can be bundled in a package with other scripts. Any suggestions (8 Replies)
Discussion started by: Jcpratap
8 Replies

12. AIX

How to deal with Tar error ?

Hello Folks, while making a tar file, got this error root@clodb:/clodbvg>/opt/freeware/bin/tar cvf - /oradata | gzip > /clodbvg/bkp_30MAY16.tgz /opt/freeware/bin/tar: Removing leading `/' from member names /oradata/ /oradata/JAVA/ /oradata/JAVA/.toc /oradata/JAVA/Java131.rte... (16 Replies)
Discussion started by: filosophizer
16 Replies

13. What is on Your Mind?

MySQL Performance Problems

Just restarted MySQL a few times. There seems to be a problem with MySQL performance because one table (our man page table) is too large and I need to move that table to a new database and out of the main forums DB. That table is over 7 GB, bigger than the rest of the DB combined: ... (14 Replies)
Discussion started by: Neo
14 Replies