Searching database conversion script.

Discussion in 'Databases' started by mm1985, Aug 26, 2008.

  1. #1
    I need to convert the database of the Article-Directory script (yourarticlesdirectory.com) to the database of Website Publisher (www.articlelive.com).

    Does there exist a script like this, and if not how can I make it?
     
    mm1985, Aug 26, 2008 IP
  2. justinlorder

    justinlorder Peon

    Messages:
    4,160
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    0
    #2
    what are the databases? I am excellent in database conversion, maybe I could help you.
     
    justinlorder, Aug 26, 2008 IP
  3. mm1985

    mm1985 Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Wel the original database starts like this
    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Jul 06, 2006 at 08:42 AM
    -- Server version: 4.0.27
    -- PHP Version: 4.3.11
    --
    -- Database: `articlea_db`
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table `article_master`
    --

    CREATE TABLE `article_master` (
    `article_id` bigint(20) NOT NULL auto_increment,
    `article_user_id` int(11) NOT NULL default '0',
    `article_author` varchar(100) NOT NULL default '',
    `article_snippet` varchar(255) NOT NULL default '',
    `article_summary` text NOT NULL,
    `article_title` varchar(100) NOT NULL default '',
    `article_category_id` int(11) NOT NULL default '0',
    `article_views` bigint(20) NOT NULL default '0',
    `article_status` int(11) NOT NULL default '1',
    `article_date` date NOT NULL default '0000-00-00',
    `article_home_page` int(11) NOT NULL default '0',
    `article_email` int(11) NOT NULL default '0',
    PRIMARY KEY (`article_id`)
    ) TYPE=MyISAM AUTO_INCREMENT=283404 ;

    --
    -- Dumping data for table `article_master`
    --

    INSERT INTO `article_master` VALUES (1, 0, 'Ray Coleiro', ' Discipline and good behavior are not just for your Dog they apply to you, the pet-parent too. Buying a dog is not all <br><br>“cochie coo” business -', ' Discipline and good behavior are not just for your Dog they apply to you, the pet-parent too. Buying a dog is not all <br><br>“cochie coo” business -- it signals the beginning of a lifetime of commitment and responsibility. <br><br>1.Love your dog unquestioningly. Treat him like a friend. Never hurt, punish, beat or abandon him. Seek professional <br><br>help if you are ever pushed against the wall – there are feasible solutions to everything. <br>2.Ensure good nutrition.<br>3.Take an informed decision about spaying/neutering.<br>4.Give him good veterinary care. Half yearly check ups, vaccinations, dental check ups, and more.<br>5.Ensure that all his papers are in order – get him an ID and license. <br>6.Training is a key to a long and fulfilled life.<br>7.Groom him everyday or as many times as necessary. Grooming is one way of bonding with your dog. <br>8.Socialize your dog from day one – this will help him be comfortable around other people and animals as well as in <br><br>public places.<br>9.Devote at least 30 minutes everyday to play with your dog.<br>10.Ensure that you are a lawful dog owner-- obey all leash, vaccination, and noise pollution laws. <br>11.Always clean up after your dog – it prevents infections.<br>12.Exercise your dog for at least 30 minutes each day.<br><br>These golden rules will help you grant the boon of a good life to your dog and believe me a dog that leads a well balanced <br><br>life hardly ever develops any behavioral problems. <br><br>Whether you are a first time dog owner or a seasoned veteran, your learning never stops as far as it comes to training your <br><br>dog. Each and every dog presents different training challenges, and the more equipped you are to handle these training issues <br><br>the more likely you are to prevent any permanent and long term future behavioral problems. <br><br>If you are serious about your dog, and want the very best for her/him, then you owe it to your best friend to get a copy of <br><br>this FREE Dog Training Mini-Course. You can still get it from here:<br><br>http://www.dogtrainingmastery.com/Free_Dog_Training/dog-obedience-training.htm<br><br><br><p> About the Author \n<p>Ray Coleiro is the author of the popular book "Dog Training Mastery - An Owner''s Manual!" To learn more about his proven Dog Training methods and life''s work, you can visit <br>http://www.dogtrainingmastery.com/Dog_Training/dog-training.htm<br>Note: The author grants permission to you to re-print, pulish or broadcast this article so long as it is un-altered or not edited in any way, and that all links remain present and active.', '12 Golden rules for every Dog owner', 2, 2, 1, '2005-12-01', 0, 1);
     
    mm1985, Aug 26, 2008 IP
  4. mm1985

    mm1985 Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    While the script of articlelive works like this:

    see link because it is to big to write it down

    article-magazine.org/example_sql.txt
     
    mm1985, Aug 26, 2008 IP
  5. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #5
    which is the old script u used for that db ?
     
    chandan123, Nov 20, 2008 IP