Announcement

Collapse
No announcement yet.

Snitz import for dummies (MS-SQL or MS-Access)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    You're welcome.

    Leave a comment:


  • kerrya
    replied
    Steve! You did it. That was it exactly.
    Thank you so much.
    Kerry

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Are you sure it's not this:

    How Do I Set Forums to Display All Posts
    http://www.vbulletin.com/forum/showthread.php?t=191791

    Leave a comment:


  • kerrya
    replied
    OK. Figured out banned users. I'm just now noticeing not all posts and threads came in.

    Oh well. retry
    Kerry

    Leave a comment:


  • kerrya
    replied
    users are banned after import

    Users are resetting their passwords, but getting a message saying:

    You have been banned for the following reason:
    No reason was specified.
    Date the ban will be lifted: Never

    In the CP, if I click on banned users I get nothing. Nobody is banned.

    Any ideas?
    Thanks
    Kerry

    Leave a comment:


  • kerrya
    replied
    very close now

    Thanks Jerry, with that last message I think I am almost home.

    The problem with the table names seems to be restricted to the trial version of the Intellegent Converters software. When I purchased the full version the problem went away.

    I have done the import, and I went into maintenence and ran all of the index updates, and all is looking good except for one thing.

    When I click on memberlist i see only the admin. When I go into the CP, I see them all and they are all editable.

    The forums and posts came in fine, and the posts all have the right username attached.

    Any idea why members dont show?

    Thanks for your help
    Kerry

    Leave a comment:

  • Jerry
    Senior Member

  • Jerry
    replied
    Not sure what's going on with the table name though you can re-name it, unless it's a newer version I haven't seen.

    In ImpExConfig you have this directive you can set at the bottom :

    PHP Code:
    define('lowercase_table_names'true); 

    Leave a comment:


  • kerrya
    replied
    help with Snitz import please

    I am trying to convert a very small Snitz forum over to the latest version of vB.

    I downloaded the trial version of Intelligent Converters, and did a direct import into MySQL database.

    I had set up the MySQL database thru phpMYadmin and left it empty, leaving the converter to populate the fields.

    Two issues.
    1) Many table names are failing. ie. FORUMS_CATEGORY winds up as forums_cat_gory

    2) The target database tabe names are in lowercase. It seems like IMPEX is seeking uppercase tabel names as IMPEX is not finding the table names that do come over correctly.

    Any help appreciated.

    Thanks
    Kerry

    Leave a comment:


  • ALcorn
    replied
    try the following (assuming your database is in standard latin1 encoding):
    mysqlimport -h host -u username -p --character-sets-dir=latin1 dbname c:\dbdump.sql

    But there could be some problems with delimiters, fields enclosing caracters etc...

    If this is not working as is, then try to include the following parameters in my.ini file and restart Mysql then:
    Code:
    [mysqlimport]
    fields-terminated-by=;
    default-character-set=latin1
    fields-enclosed-by="
    lines-terminated-by=\r\n
    Last edited by ALcorn; Thu 7 Feb '08, 4:10am.

    Leave a comment:

  • gpspassion
    New Member

  • gpspassion
    replied
    No luck so far, it is complaining about the syntax, maybe the path to the file. Ok, I was trying to type that from the console, duh, couldn't work, let me try from the DOS prompt, can it be done directly in the console?

    UPDATE - it's crunching...

    This script looked promising http://www.ozerov.de/bigdump.php but I am getting "At this place the current query includes more than 300 dump lines." errors...
    gpspassion
    New Member
    Last edited by gpspassion; Mon 4 Feb '08, 9:18am.

    Leave a comment:

  • gpspassion
    New Member

  • gpspassion
    replied
    Thanks had just found this mysql -u username databasename < filename.txt but it seemed to be missing handles, yours looks better, let me drop what got imported so far and try that.

    Leave a comment:


  • ALcorn
    replied
    mysql -h host -u user -p dbname < dump.sql

    Leave a comment:

  • gpspassion
    New Member

  • gpspassion
    replied
    Yes, being rather new at this I was using phpMyAdmin, not sure what the syntax in the mysql console should be, will try to look it up.

    Leave a comment:


  • ALcorn
    replied
    How you import the dump in MySQL? Via console or phpMyAdmin? Big dumps should be imported via the mysql console.

    Leave a comment:

  • gpspassion
    New Member

  • gpspassion
    replied
    Thanks, looks like the connection is ok based on your sricpt.

    So I tried to import a 732MB .sql in MySql and naturally it was too large so I bumped up the limits to 1000MB, but now I am getting time-outs, and the data is not getting imported correctly...don't know if the limit can be raised with shlomot must have figured that out, hopefully he is still around !

    One problem after the other, eh ! sigh...

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X