1
Will_H
user tables?
  • 2005/10/16 12:45

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


I am setting up a subdomain with a full install of 2.0.13.

Operating system Linux
Apache version 1.3.33 (Unix)
PERL version 5.8.7
PHP version 4.3.11
MySQL version 4.0.25-standard

My problem is that when i try to export the user table from one domain i cannot get it to import to the new domain without erroring out. What is the best way to transfer user data? is their specific export rules? or is there a secret to the import. Thanks guys.


*** note i have been all over mysql.com and cant find this, so if you know of a linky ***

2
JMorris
Re: user tables?
  • 2005/10/16 12:55

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


How large is the SQL file you're trying to import? If it's over 2MB, you'll need to use a Staggered MySQL Dump Importer, like Bigdump.

Hope this helps.

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

3
Will_H
Re: user tables?
  • 2005/10/16 23:27

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


the one i am trying to use is only 19.7 k, but i am running multiple subdomains and i would like the user tables to contiue to be identical.

4
JMorris
Re: user tables?
  • 2005/10/17 0:51

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


Well, the file is small enough.

Are the evironments the same (i.e.: XOOPS Version, MySQL Version).

How are you exporting the data? Are you using phpMyAdmin? If so, what options are you using?

In phpMyAdmin, the only options I usually select are..

Structure:
Add DROP TABLE
Add AUTO_INCREMENT value

Data:
Use hexadecimal for binary fields

Best Regards,

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

5
Will_H
Re: user tables?
  • 2005/10/17 2:37

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


Has anyone told you that you were the man lately? Cuz ya are.... no no no i mean it! Thanks, worked great.

Login

Who's Online

208 user(s) are online (32 user(s) are browsing Support Forums)


Members: 0


Guests: 208


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits