BAcking up DB with a admin.php

swisschese · New Member Joined: Jun 30, 2006 Posts: 21

Hello again!

Another problem i have run into, is when backing up the database through the admin.php it wants to save it as admin.php instead of a SQL.

Anythoughts?

Thanks once again

Swiss Shocked

swisschese · New Member Joined: Jun 30, 2006 Posts: 21

Database saved :
# On 07-03-2006 at 04:01 by !
#
# ========================================================

# --------------------------------------------------------
#
# Table structure for table 'nuke_authors'
#

CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL,
name varchar(50),
url varchar(255) NOT NULL,
email varchar(255) NOT NULL,
pwd varchar(40),
counter int(11) DEFAULT '0' NOT NULL,
radminsuper tinyint(1) DEFAULT '1' NOT NULL,
admlanguage varchar(30) NOT NULL,
PRIMARY KEY (aid)
);

#
# Dumping data for table 'nuke_authors'

There's a sample.. can i rename to .sql and call it a day?

I downloaded the 12mb .php file and opened it in notepad and that's the results

jaded · Theme Guru Joined: Nov 01, 2003 Posts: 1006

it is fine. You can leave it as it is. That is the same that happens for me. It works just the same.

montego · Posted: Thu Jul 06, 2006 7:04 am

Just something to recall down the road: as your database grows and grows, there will come a time when the backup utility that is built into Nuke will fail to work. You may want to use something like phpMyAdmin to do your exports. But, that is just an fyi for the future...

swisschese · New Member Joined: Jun 30, 2006 Posts: 21

Good Idea.

And for backing up the forums. jus use the built in backup? or does the myphp myadmin
do the same?

Guardian2003 · Posted: Thu Jul 06, 2006 1:59 pm

myphpadmin can be used to back up the entire database as well as individual, specific tables.

swisschese · New Member Joined: Jun 30, 2006 Posts: 21

Ok guys i am back!!! i know i know idon't jump at this all at once.

I exported it all thru the php admin screen, it was only 1.84mb. i backed it up thru the website, and it was 30mb..

Which one am i to use?

i am moving my whole site, to another domain and i need to make sure that i got EVERYthing..

Guardian2003 · Posted: Fri Jul 28, 2006 12:38 pm

Use phpmyadmin and make sure you select to use data and tables and 'complete inserts'.