We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

re: data importer | Forum

Stan
Stan Apr 17 '12
I have followed everything to the letter and still It will not upload my data importer, I have checked and rechecked my cron job and it is correct so why am I still having this problem, please I need help.

my website is my diary Book I have just recently moved from wall.fm to Oxwall.

Kind regards

Stan
Adhy Musaad
Adhy Musaad Apr 17 '12
You may have to go for Manual Import.


Unzip your Back up File, And in each dump.sql file, You will have some things saying " %%TBL-PREFIX%% ". Change that text into " ow_ " and then import the files into the MySQL Database using PhpMyAdmin.


"BACKUP SITE"

Adhy Musaad
Adhy Musaad Apr 17 '12
Manual import
Stan
Stan Apr 19 '12
Thank you for the advice Adhy Musaad but I wouldn't be able to do that because I know I would make a mistake.
Adhy Musaad
Adhy Musaad Apr 19 '12

you simply use Notepad + + to search for that keyword and replace it.

Notepad + + can replace these keywords are all within 1 minute


but the thing to remember I did not succeed in importing the user, through this way. This will serve to move the Blogs, Links, Messages, Status and Events


you can try but you have to back up first

Stan
Stan Apr 20 '12
ok thank you Adhy :)

Stan
Stan Apr 20 '12
I tried what you said but when I imported it is saying syntax error?
Stan
Stan Apr 20 '12
This is what comes up when I try to import my files dump.sql:1: ERROR: syntax error at or near "DROP"
LINE 1: DROP TABLE IF EXISTS "ow_"base_authorization_action;
^
dump.sql:10: ERROR: syntax error at or near "`"
LINE 1: CREATE TABLE `"ow_"base_authorization_action` (

Adhy Musaad
Adhy Musaad Apr 20 '12
from where you import them?


Step by Step:

PhpMyAdmin => Import => Import dump.sql => done

Joseph
Joseph Apr 20 '12
nope I tried the same and its not working I get the same error
Adhy Musaad
Adhy Musaad Apr 21 '12
It definitely works, I've never tried it. you need to reread what I said above
Joseph
Joseph Apr 21 '12
so you have never tried this yet you are telling me it works when I have just done as you said and he did too well how about this I will make you a video
Adhy Musaad
Adhy Musaad Apr 21 '12

I succeeded, move the blog, links and others unless the user ..

you have to go into phpadmin and upload one by one.

This all should work.

I tried it and it worked, but I did not try to move users

Stan
Stan Apr 21 '12
I tired that Adhy and it didn't work it just messed my website up I must of done it wrong?
Adhy Musaad
Adhy Musaad Apr 21 '12
It worked, and did not fail, one by one at a time and see the results. certainly will succeed