SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Addict
    Join Date
    Mar 2008
    Location
    Sterling, CO
    Posts
    275
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Moving Sql Database

    Hi,

    I'm trying to move my database to another server.

    I'm new at sql. I've so far downloaded the database to a wordpad file on my desktop from the old server. When I try to import it to the new server sql I get the error that's it's to large (Max: 2,048KiB) the file I'm moving is about 2100 ...little to much I guess.

    I then tried gziping it and importing it, but then get the error: (You attempted to load file with unsupported compression (application/gzip). Either support for it is not implemented or disabled by your configuration.)

    How can I import it?

    Thanks

  2. #2
    masquerading Nick's Avatar
    Join Date
    Jun 2003
    Location
    East Coast
    Posts
    2,215
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Do you have phpMyAdmin access to this database? I know phpMyAdmin offers many download formats, including pre-compressed formats.
    Nick . all that we see or seem, is but a dream within a dream
    Show someone you care, send them a virtual flower.
    Good deals on men's watches

  3. #3
    SitePoint Addict
    Join Date
    Mar 2008
    Location
    Sterling, CO
    Posts
    275
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes, I have access. But don't know much about how to use it.

  4. #4
    masquerading Nick's Avatar
    Join Date
    Jun 2003
    Location
    East Coast
    Posts
    2,215
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When you log into phpMyAdmin and select a DB for use, you should see an option to "Export Database". Look through the options (they have .txt, .sql, .gzip, etc) and select one to download. Then on your new server you go to the same area, expect click "Import Database" and use the file you downloaded.
    Nick . all that we see or seem, is but a dream within a dream
    Show someone you care, send them a virtual flower.
    Good deals on men's watches

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    possibility- that won't work. he already said that the target server has gzip support disabled.

    freejoy- just open the file in notepad or wordpad, and use copy-and-paste to split the file in half. just make sure to do it between statements.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  6. #6
    SitePoint Addict
    Join Date
    Mar 2008
    Location
    Sterling, CO
    Posts
    275
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So, you split it into two smaller files?


    Here's some of the database, I would split it where I have it highlighted in red?

    Code:
      `username` varchar(60) NOT NULL default '',
      `ordernum` int(10) NOT NULL default '0',
      PRIMARY KEY  (`recno`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `livehelp_qa`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `livehelp_questions`
    -- 
    
    CREATE TABLE `livehelp_questions` (
      `id` int(10) NOT NULL auto_increment,
      `department` int(10) NOT NULL default '0',
      `ordering` int(8) NOT NULL default '0',
      `headertext` text,
      `fieldtype` varchar(30) NOT NULL default '',
      `options` text,
      `flags` varchar(60) NOT NULL default '',
      `module` varchar(60) NOT NULL default '',
      `required` char(1) NOT NULL default 'N',
      PRIMARY KEY  (`id`),
      KEY `department` (`department`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
    
    -- 
    -- Dumping data for table `livehelp_questions`
    -- 
    
    INSERT INTO `livehelp_questions` (`id`, `department`, `ordering`, `headertext`, `fieldtype`, `options`, `flags`, `module`, `required`) VALUES 
    (1, 1, 0, 'E-mail:', 'email', '', '', 'leavemessage', 'Y'),
    (2, 1, 0,
    
    


    Is that what you mean by spliting it "between statments"?

  7. #7
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    no, definitely not there. a semicolon (;) is at the end of a statement. so split it right after a semicolon.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  8. #8
    SitePoint Addict
    Join Date
    Mar 2008
    Location
    Sterling, CO
    Posts
    275
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Splitting it right after a semicolon worked perfect. Thank you


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •