sajjadnaveed

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Forum: Fixing WordPress
    In reply to: Building locally, then uploading
    sajjadnaveed

    (@sajjadnaveed)

    18 years, 6 months ago

    Here I will paste the trick I did.

    While exporting MySQL Dump file from latest version it was adding following lines at start

    -- Host: localhost
-- Generation Time: Oct 31, 2007 at 01:14 PM
-- Server version: 5.0.45
-- PHP Version: 4.4.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    I removed the following lines from each table

    -- Server version: 5.0.45
-- PHP Version: 4.4.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    `

    and after doing this trick to all tables and importing each table. I got my blog live. 🙂

    Regards,
    Sajjad Naveed

    Forum: Fixing WordPress
    In reply to: Building locally, then uploading
    sajjadnaveed

    (@sajjadnaveed)

    18 years, 6 months ago

    Hello Salam Guys,

    I hope every one out there is enjoying life.

    I was also having the same scenario.

    Infact I developed my blog locally with WAMP server with same specifications as mentioned above and never realized that I can face such problem of importing the MySQL DB on live web host.

    Well just today morning I had to upload it online. I uploaded all my content files through ftp. And when I tried to import my database, I had to face the problem of version compatibility.

    I was searching for some help and then I came to this post. I read it and after few minutes I tried a trick… I modified each db table and then imported it separately to new db
    Thanks to Allah, its working fine now. Up till now everything is fine and I am still checking with, I hope everything will be smooth.

    Cheers 🙂

    Sajjad Naveed

Viewing 2 replies - 1 through 2 (of 2 total)