I successfully imported many of my static files locally (in my PC). Then I set up a test site at my webhost.

After I imported the database from my localhost to the webhost, everything seems to be fine except that all of the imported content is gone.

Please help!

Comments

dman’s picture

dman commented

That sounds like more of a transfer issue than an import one.
How did you transfer the database? A total SQL dump? Nothing in the node table? Nothing in the content management screens?

dwees’s picture

dwees commented

The Node revisions table is rather large. I've noticed that it sometimes get cut off in the middle of a transfer etc... as a result.

I would do the transfer again, starting with a fresh install, but transfer the node_revisions table separately from the other tables in the database.

Dave

deadlyminds’s picture

deadlyminds commented

dman - I don't know what a SQL dump is; I use the import function in phpmyadmin and downloaded a sql file (all the tables checked).

dwees - what does the 'node_revisions' table contain?

I saw somewhere in the forums that the problem has more to do with the transfer rather than Import HTML itself. Someone mentioned about clearing the cache table..

dman’s picture

dman commented

The SQL dump is the file you would have got when you exported the source database.

Look at your destination database 'node' and 'node_revisions' tables, using phpmyadmin or something and see if the data has arrived there. Node revisions contains the actual text nowadays, although in earlier drupals that was (also) in the 'node' table itself IIRC.

If it worked locally, but not remotely, and the Drupal versions are the same, it's your transfer that failed.
As a last resort, you could try doing the whole import again remotely, although that's probably messier (and harder/impossible if the remote host doesn't have the XSL & Tidy extensions).

dman’s picture

dman commented
Status: Active » Closed (fixed)

Can't do anything more here