We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 22162
    • 2 Posts
    I am having trouble importing my database from my local mamp server to a web server... this is the error I get:

    Error

    SQL query:

    -- -- Database: `pcf` -- -- -------------------------------------------------------- -- -- Table structure for table `modx_actiondom` -- CREATE TABLE `modx_actiondom` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `set` int(11) NOT NULL DEFAULT ’0’, `action` int(11) NOT NULL DEFAULT ’0’, `name` varchar(255) NOT NULL DEFAULT ’’, `description` text, `xtype` varchar(100) NOT NULL DEFAULT ’’, `container` varchar(255) NOT NULL DEFAULT ’’, `rule` varchar(100) NOT NULL DEFAULT ’’, `value` text NOT NULL, `constraint` varchar(255) NOT NULL DEFAULT ’’, `constraint_field` varchar(100) NOT NULL DEFAULT ’’, `constraint_class` varchar(100) NOT NULL DEFAULT ’’, `active` tinyint(1) unsigned NOT NULL DEFAULT ’1’, `for_parent` tinyint(1) unsigned NOT NULL DEFAULT ’0’, `rank` int(11) NOT NULL DEFAULT ’0’, PRIMARY KEY (`id`), KEY `set` (`set`), KEY `action` (`action`), KEY `name` (`name`), KEY `active` (`active`), KEY `for_parent` (`for_parent`), KEY `ran[...]

    MySQL said: Documentation
    #1046 - No database selected


    Can anyone decipher this? Im new at this!
    I exported the whole database of the modx site i want to transfer to the new one, but not including the access files.
      • 33968
      • 863 Posts
      Sounds like you might not have created a database on the target server. Are you trying to import it using phpMyAdmin?

      Have a look at the following wiki article which will walk you through a first time installation on a remote server:
      http://wiki.modxcms.com/index.php/Moving_Site_To_Another_Location