Restore database with phpmyadmin :: Zikula Community

Start [1]
Search [2]
latest posts [3]
RSS [4]
Login [5]
Register [6]

[10]
Print topic [11]
[12]

Start [13] ::
PostNuke 0.7 Support [14] ::
Installation, Configuration, & Upgrades [15] ::
Restore database with phpmyadmin

Moderated by:
Support [16]

[17]

Restore database with phpmyadmin

[18]Posted: 27.01.2003, 07:27

[19]

rank:

Helper

registered:

November 2002

Status:

offline

last visit:

17.02.05

Posts:

135

This is the error message I get when I try to restore my SQL database into an empty database with phpmyadmin:

[php:1:ba0ec7541d][/php:1:ba0ec7541d]
[20]
- notify mod [21]
[23]Posted: 07.03.2003, 00:12

[24]

rank:

Helper

registered:

February 2003

Status:

offline

last visit:

14.10.03

Posts:

109

how do you restore a data base with phpMyAdmin [25]?
[26]
- notify mod [27]
[29]Posted: 07.03.2003, 01:56

[30]

rank:

Helper

registered:

December 1969

Status:

offline

last visit:

17.01.05

Posts:

316

Yeah, I think that we need a little more information.

Are you sure that nuke_autolinks isn't already created (meaning that you currently have a blank database)
[31]
- notify mod [32]
[34]Posted: 07.03.2003, 03:32

[35]

rank:

Moderator

registered:

March 2002

Status:

offline

last visit:

26.08.08

Posts:

7720

rcillig
how do you restore a data base with phpMyAdmin [36]?

Answered in this thread.

-Mark
[37]
- notify mod [38]
[40]Posted: 07.03.2003, 03:34

[41]

rank:

Moderator

registered:

March 2002

Status:

offline

last visit:

26.08.08

Posts:

7720

torminator
This is the error message I get when I try to restore my SQL database into an empty database with phpmyadmin:

What was the SQL file created with? The comments put into an export from MySQL on the command line don't necessarily work when importing with phpMyAdmin [42] and vice versa.

Try trimming all the comments out of the SQL file and see if this helps.

-Mark
[43]
- notify mod [44]
[46]Posted: 07.03.2003, 04:38

[47]

rank:

Helper

registered:

November 2002

Status:

offline

last visit:

17.02.05

Posts:

135

Thx for replying markwest but I got it working a long time ago and consider myself no longer as a MySQL newbie. More like a MySQL almost nebie.

I got it working as I said but can't remember what was wrong.

Only thing I feel pretty sure about was that it was NOT a phpMyAdmin [48] problem. It is more likely it was a usermistake (by me) *lol*

I actually now find it quite comfortable to work with SQL databases. One month ago I would never had thought that possible. Amazing what endless of hours infront a computer will do to you.
[49]
- notify mod [50]
[52]Posted: 07.03.2003, 13:00

[53]

rank:

Moderator

registered:

March 2002

Status:

offline

last visit:

26.08.08

Posts:

7720

torminator
Thx for replying markwest but I got it working a long time ago and consider myself no longer as a MySQL newbie. More like a MySQL almost nebie.

I got it working as I said but can't remember what was wrong.

Only thing I feel pretty sure about was that it was NOT a phpMyAdmin [54] problem. It is more likely it was a usermistake (by me) *lol*

I actually now find it quite comfortable to work with SQL databases. One month ago I would never had thought that possible. Amazing what endless of hours infront a computer will do to you.

Sorry about that didn't notice the date on the original post as it has been pushed back to the top.

-Mark
[55]
- notify mod [56]

Users online:

AllKnightAccess [58],
Topiatic [59],
dp2 [60],
emathieu [61],
lpa@farumkyokushin.dk [62],
philipp2 [63],
slam [64]

This list is based on the users active over the last 60 minutes.

rcillig

torminator

torminator