1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need my godaddy MySQL in stalled

Discussion in 'Custom Service/Development Requests' started by Market1234, Feb 12, 2015.

  1. Market1234

    Market1234 Member

    i accidently wiped my site off and can't seem to reload it from my backup MySQL file from godaddy. Msg me if interested and how much.
     
  2. The Forum Heroes

    The Forum Heroes Well-Known Member

    Do you have a .sql file of a backup?
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

  4. Market1234

    Market1234 Member

    Yes, but as brogan said there are issues.
     
  5. The Forum Heroes

    The Forum Heroes Well-Known Member

    As Brogan mentioned, you'll need to open it in an editor like notepad++ and paste the 1st few lines.

    Also cPanel backups are pure garbage. In the future always use phpMyAdmin to create a dump or if you have SSH access, create the dump using the mysqldump shell command.
     
  6. BoostN

    BoostN Active Member

    Download 7zip and decompress it until you see the .sql file extension. Then open it up in Notepad ++ (must download that as well) and post the first few lines.
     
  7. Market1234

    Market1234 Member

  8. Market1234

    Market1234 Member

    -- cPanel mysql backup
    GRANT USAGE ON *.* TO 'clubcensus'@'160.153.73.160' IDENTIFIED BY PASSWORD <snipped by mod>;
    GRANT ALL PRIVILEGES ON `i1095895\_wp4`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `i1095895\_wp3`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `ftpg`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `back`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `i1095895\_wp2`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `Tests`.* TO 'clubcensus'@'160.153.73.160';
    GRANT ALL PRIVILEGES ON `i1095895\_wp1`.* TO 'clubcensus'@'160.153.73.160';
    GRANT USAGE ON *.* TO 'clubcensus'@'50.62.177.55' IDENTIFIED BY PASSWORD <snipped by mod>;
     
    Last edited by a moderator: Feb 13, 2015
  9. Market1234

    Market1234 Member

    not sure which one:

    -- MySQL dump 10.13 Distrib 5.5.41, for Linux (x86_64)
    --
    -- Host: localhost Database: ftpg
    -- ------------------------------------------------------
    -- Server version 5.5.41-cll-lve

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

    --
    -- Table structure for table `xf_addon`
    --

    DROP TABLE IF EXISTS `xf_addon`;
    /*!40101 SET @saved_cs_client = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    CREATE TABLE `xf_addon` (
    `addon_id` varbinary(25) NOT NULL,
     
  10. Robust

    Robust Well-Known Member

    Second one would be your XenForo database. The first seems to be the cPanel privileges one (and I would use different passwords this time around too :p)

    I'll take a look at the thread Brogan linked.

    Edit: Which one are you uploading to restore? Upload the second one to restore in cPanel -> phpMyAdmin (or using ssh is preferred if you have access to that).
     
  11. Market1234

    Market1234 Member

    This has be fixed, please close
     

Share This Page