SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru
    Join Date
    Mar 2004
    Posts
    639
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Restoring MySQL backup, how to fix errors?

    Hello,

    I'm transferring MySQL database from Linux server to Windows Server 2008 server.

    I've done backup of all tables with MySQL Administrator. Now, I'm trying to restore that backup on Windows machine and get errors.

    For example:

    Error while executing this query:CREATE TABLE `top` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `site` varchar(200) NOT NULL,
    `email` varchar(200) NOT NULL,
    `comment` varchar(255) NOT NULL,
    `email_top` tinyint(3) unsigned NOT NULL,
    `opisanie` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    The server has returned this error message:Error writing file '.\geopromotion\top.frm' (Errcode: 28)
    MySQL Error.
    Both Linux and Windows MySQL setups have utf8 encoding.

    I wonder how can I fix it?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    i googled Errcode 28 and found a bunch of results talking about insufficient disk space

    what did you find?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •