We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 6531
    • 154 Posts
    [insensitive text removed -- apologies]

    I did a ’dump’ from the ’export’ section of phpMyAdmin -- where there are a million options, which I just left as is -- and generated a .sql file.

    But when I try to ’import’ that file into my new database on the new server, it tells me:
     Error
    SQL query:
    
    -- phpMyAdmin SQL Dump
    -- version 2.9.1.1
    -- http://www.phpmyadmin.net
    -- 
    -- Host: 10.6.166.235
    -- Generation Time: Sep 01, 2008 at 06:38 PM
    -- Server version: 5.0.67
    -- PHP Version: 4.4.4
    -- 
    -- Database: `zzzz`
    -- 
    -- --------------------------------------------------------
    -- 
    -- Table structure for table `modx_active_users`
    -- 
    CREATE TABLE  `modx_active_users` (
     `internalKey` INT( 9 ) NOT NULL DEFAULT  '0',
     `username` VARCHAR( 50 ) NOT NULL DEFAULT  '',
     `lasthit` INT( 20 ) NOT NULL DEFAULT  '0',
     `id` INT( 10 ) DEFAULT NULL ,
     `action` VARCHAR( 10 ) NOT NULL DEFAULT  '',
     `ip` VARCHAR( 20 ) NOT NULL DEFAULT  '',
    PRIMARY KEY (  `internalKey` )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT =  'Contains data about active users.';
    
    
    MySQL said: 
    
    #1050 - Table 'modx_active_users' already exists 
    


      • 6531
      • 154 Posts
      It worked after I DROPPED all the tables in the default install database.
        • 28042 ☆ A M B ☆
        • 24,524 Posts
        I’m trying to migrate a site from one server to another, and I have to say, the ’instructions’ on moving servers, are EXTREMELY LAX, esp. to someone like me who knows practically nothing about MySQL!

        This is support and documentation for MODx, not MySQL. There are tons of tutorials on the Internet for HTML, CSS, PHP, and MySQL. If a person has no knowledge of any of these, he will have serious problems trying to be a web developer and site administrator. It’s like a person with no training trying to repair and maintain his computer monitor. Well, except that it won’t kill you if you accidentally touch the wrong part...


          Studying MODX in the desert - http://sottwell.com
          Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
          Join the Slack Community - http://modx.org
          • 6531
          • 154 Posts
          Sorry, Susan, you’re absolutely right. I was just frustrated by my own lack of knowledge. No offense to Doc Team intended!

          The ’problem’ -- to MODx’s credit - is that I’ve managed to build a rather sophisticated site without knowing ANYTHING about MySQL!

          When I have some time ... I’ll add some ’newb’ notes to the wiki...
            • 28042 ☆ A M B ☆
            • 24,524 Posts
            As a completely self-taught "techno-geek-girl", I can certainly empathize with the frustration! But keep it up, in 15 years you, too can have a fairly decent practical knowledge of many aspects of programming and administration. But I would strongly recommend some formal courses (not the online crap; they don’t even provide a decent looking certificate; yes, O’Reilly Learning Lab, I mean you... wasting thousands of dollars for what can be learned just as easily with half a dozen good free online tutorials!) to get the theory; I’m suffering badly from that lack in trying to get a grip on MODx 2.0-also-known-as-Revolution.
              Studying MODX in the desert - http://sottwell.com
              Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
              Join the Slack Community - http://modx.org