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. Beginner's Corner 
  4.  / How to export database with PHPmyadmin?
Register
1
Ronaldus
How to export database with PHPmyadmin?

  • 2004/10/29 10:19

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


I'm putting my local site to remote.
How can I transfer my database (containing 70 tables) with PHPmyadmin?

I use the 'export' page in PHPmyadmin.
I select all tables.
Should I check 'complete' or 'extend' inserts?
Save as file? What kind of file? sql or txt?

And how to import om remote database?

Thanks in advance and greetings,

Ronaldus
2
zoullou
Re: How to export database with PHPmyadmin?

  • 2004/10/29 10:29

  • zoullou

  • Quite a regular

  • Posts: 250

  • Since: 2004/3/2 0


Quote:

Ronaldus wrote:
I use the 'export' page in PHPmyadmin.
I select all tables.
Should I check 'complete' or 'extend' inserts?
Save as file? What kind of file? sql or txt?

Export, sel all tables, save as file (gzippé).

To import your database, in PHPMyAdmin, SQL, and select your file.
3
Ronaldus
Re:How to export database with PHPmyadmin?

  • 2004/10/29 11:12

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


I did that. When I select this .sql file from the remote MySQLadmin it starts to download, so everythings seems right.
At the end I get the message something went wrong with the avatar table.
But the other tables aren't visible as well!!

Any idea?

Thanks,

Ronaldus
4
ackbarr
Re:How to export database with PHPmyadmin?

I export with 'Complete Inserts' on and 'Extended Inserts' off.
5
Ronaldus
Re:How to export database with PHPmyadmin?

  • 2004/10/29 12:12

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


This is what I get when I import the .sql file to the remote server.
I tried with auto-increment on and off and several other options.

Who can tell me what this means?
I tried to upload a single random table, but get the same message everytime...
Here we go:

SQL-query :

CREATE TABLE `xoops_avatar` (

`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =32

MySQL returned:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32' at line

Thanks and greetings
Ronaldus
6
DonXoop
Re:How to export database with PHPmyadmin?

I have exported with most of the defaults and only selected gzipped which then selects As File. No problem.

My guess is that the other end doesn't like "CHARSET=latin1". My exports don't have that option. What version of MySQL is at either end. And what version of phpMysqladmin?
7
Ronaldus
Re:How to export database with PHPmyadmin?

  • 2004/10/29 13:09

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


My provider runs MySQL 3.23.30 and phpMyAdmin 2.5.6.
I made the XOOPS site locally with the standard XSAS server.
Could there be a 'compatibility' problem?

Thanks for replying,

Ronaldus
8
DonXoop
Re:How to export database with PHPmyadmin?

Those are outdated versions but should be "good enough". I would suggest using a stand alone updated version of phpmyadmin. There are security issues with the version you mention.

Have you tried exporting all tables except avatars? Do you get the same error with other tables? You can always import an individual table later. You can edit the export file and remove the CHARSET=latin1 option.

I don't know xsas but there might be MySQL options to turn off the charset option. As far as I know latin1 is the default charset anyway.
9
Ronaldus
Re:How to export database with PHPmyadmin?

  • 2004/10/29 13:25

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


When I try other tables I get the same error message, indeed.
Can I edit the export in Wordpad?
Then I'll try that.
10
Ronaldus
Re:How to export database with PHPmyadmin?

  • 2004/10/29 13:41

  • Ronaldus

  • Friend of XOOPS

  • Posts: 389

  • Since: 2004/5/8 1


Very strange !!!

I decided to delete the whole remote site, and perform a clean XOOPS online install. Runs smoothless.
All tables are there.

But when I compare tables which are online now with the ones on my local PC, I see there is an extra column locally called 'Collation'.

Could this cause the problem?
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

261 user(s) are online (40 user(s) are browsing Support Forums)

Members: 0

Guests: 261

more...

Donat-O-Meter

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

Latest GitHub Commits