Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Aug 2011
    Posts
    1
    Member #
    29108
    I have changed my server from Windows to Linux. My hosting company has transferred all the data but DBs.

    They have asked me to do it myself, and ive been working on it for a week now but always fail.

    I xport the file from old server then go to myPHPADMIN on new server and upload but get this error.

    Error

    SQL query:

    --
    -- Database: `forums_`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `forums_admin_info_files`
    --
    CREATE TABLE `forums_admin_info_files` (
    `id_file` tinyint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
    `filename` varchar( 255 ) NOT NULL DEFAULT '',
    `path` varchar( 255 ) NOT NULL DEFAULT '',
    `parameters` varchar( 255 ) NOT NULL DEFAULT '',
    `data` text NOT NULL ,
    `filetype` varchar( 255 ) NOT NULL DEFAULT '',
    PRIMARY KEY ( `id_file` ) ,
    KEY `filename` ( `filename` ( 30 ) )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =8;

    MySQL said: Documentation
    #1046 - No database selected


    can anyone help?

    site been down for too long now.

  2.  

  3. #2
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    modify the sql file the line that says...

    --
    -- Database: `forums_`
    --

    remove the ending underscore.... some DB's are setup to start and end with a char or num...

    if it does go, and this is truely the DB name, them you'll prpbably have to modify your PHP scripts for the DB name change

    also check to see if you're trying to upload a MYISAM DB into a INNODB DB space.


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:06 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com