XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / mysql data importing
Register
1
vkrew
mysql data importing

  • 2004/10/11 20:17

  • vkrew

  • Just popping in

  • Posts: 6

  • Since: 2004/9/16


Hi all!

After having some issues with the newbb modules on my site I decided to do a fresh install of the code, and import the dumped MySQL data I had saved via mysqldump.

The problem I'm having on import is this (please note my db is voltrondb and the data is voltrondb.sql):

# mysqlimport -p voltrondb voltrondb.sql
Enter password:
mysqlimport: Error: Table 'voltrondb.voltrondb' doesn't exist, when using table: voltrondb
#


I have tried mysqlimport with both the --force and --replace arguements to no avail. I would really like to keep the data from the site. Any suggestions on where to go from here?

Thanks!
vkrew
2
DonXoop
Re: mysql data importing

I don't know what options you used for the dump but I usually just:
# MySQL -p voltrondb < voltrondb.sql
3
vkrew
Re: mysql data importing

  • 2004/10/11 23:38

  • vkrew

  • Just popping in

  • Posts: 6

  • Since: 2004/9/16


Unfortunately when MySQL -p voltrondb < voltrondb.sql is attempted I come accross two issues.

First, if I have walked through the XOOPS setup procedure certain tables have already been added to the database and such errors as these are returned:

# MySQL -p voltrondb < voltrondb.sql
Enter password:
ERROR 1050 at line 11: Table 'vkrew_avatar' already exists
#


Second, if I create a new database, then add the voltrondb.sql data the XOOPS system wont go through the setup process because the entries are already in the database...

Is there an appropriate next step from here, or a work around?

thanks!
4
vkrew
Re: mysql data importing

  • 2004/10/11 23:39

  • vkrew

  • Just popping in

  • Posts: 6

  • Since: 2004/9/16


Please note, I used no options for mysqldump:

# mysqldump -p voltrondb > voltrondb.sql
5
vkrew
Re:mysql data importing

  • 2004/10/11 23:58

  • vkrew

  • Just popping in

  • Posts: 6

  • Since: 2004/9/16


I have just recreated voltrondb. Used MySQL -p voltrondb < voltrondb.sql

All data copied successfully. I have replaced the new mainfile.php and mainfile.dist.php with a copy of the original. I get a blank page. All permissions are set 775 except the template_c, cache, and uploads directories. When trying to access admin.php I don't have permission (obviously b.c blank pages don't yeild to login prompts)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

262 user(s) are online (166 user(s) are browsing Support Forums)

Members: 0

Guests: 262

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