Help.I get .php backup file

roksolana · 03-25-2007, 07:52 PM

I try to backup SQL database from my host server. It generates *.php backup file instead *.sql .. I created my database on my local comp and PHP-admin on my local machine generated *.sql backup file. I uploaded it in my host server using servers php-admin? Can I restore my database with that *.php backup file or I should convert it? Is there some mistake?or I just do not understand anything?

techjournal · 04-04-2007, 10:13 AM

It may be saved as .php as a way of preventing it from being downloaded from the server.
Assuming it is a mysql database backup, have you tried opening it in a text editor?
I would rename it to .sql and then try a restore

Bagi Zoltán · 04-04-2007, 10:17 AM

Can you log in into the php myadmin interface?

roksolana · 04-04-2007, 10:30 AM

Quote:

Originally Posted by techjournal

It may be saved as .php as a way of preventing it from being downloaded from the server.
Assuming it is a mysql database backup, have you tried opening it in a text editor?
I would rename it to .sql and then try a restore

I opened .php file. It looks the same as .sql. Will I not spoil my database if I just rename file to .sql and upload it to the server?

roksolana · 04-04-2007, 10:32 AM

Quote:

Originally Posted by Bagi Zoltán

Can you log in into the php myadmin interface?

I have access to phpadmin on the server. Should I change something there?

jumpenjuhosaphat · 04-04-2007, 10:32 AM

Open the file in WordPad and see if it looks anything like this:

Code:

-- MySQL dump 10.9
--
-- Host: localhost    Database: official_smf1
-- ------------------------------------------------------
-- Server version    4.1.21-standard

--
-- Table structure for table `smf_attachments`
--

DROP TABLE IF EXISTS `smf_attachments`;
CREATE TABLE `smf_attachments` (
  `ID_ATTACH` int(10) unsigned NOT NULL auto_increment,
  `ID_THUMB` int(10) unsigned NOT NULL default '0',
  `ID_MSG` int(10) unsigned NOT NULL default '0',

If it does, then it's a mysql backup file.

You can generate a backup from phpmyadmin.

Select the database that you want to backup from the dropdown menu.

Then click the Export tab.
In the area that is titled Exporth, highlight all of the tables that you want a copy of and select SQL from the radio list.

In the area that is titled "Save as file", select a compression method. Typically gzip works best for me.

Click go, and choose "save file" and click ok.....That should do it for you.

roksolana · 04-04-2007, 11:29 AM

Thank you, friends. I have just checked it again. My host provider staff tuned phpMyadmin and it generates a correct .sql backup file. Before it was *.php file. Thank you once more.

03-25-2007, 07:52 PM	#1
roksolana Member Join Date: Mar 2007 Posts: 200	Help.I get .php backup file I try to backup SQL database from my host server. It generates .php backup file instead .sql .. I created my database on my local comp and PHP-admin on my local machine generated .sql backup file. I uploaded it in my host server using servers php-admin? Can I restore my database with that .php backup file or I should convert it? Is there some mistake?or I just do not understand anything? __________________ roksolana-dating.com aMariner.net

04-04-2007, 10:13 AM	#2
techjournal Junior Member Join Date: Apr 2007 Posts: 14	Re: Help.I get .php backup file It may be saved as .php as a way of preventing it from being downloaded from the server. Assuming it is a mysql database backup, have you tried opening it in a text editor? I would rename it to .sql and then try a restore

04-04-2007, 10:17 AM	#3
Bagi Zoltán iWEBTOOL Moderator Contributor Join Date: Aug 2006 Location: Hungary Posts: 1,845	Re: Help.I get .php backup file Can you log in into the php myadmin interface? __________________ █ Time may come when you will need an excellent eCommerce shopping cart software █ free seo related web directory online marketing Free shopping cart

04-04-2007, 10:32 AM	#6
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Help.I get .php backup file Open the file in WordPad and see if it looks anything like this: Code: -- MySQL dump 10.9 -- -- Host: localhost Database: official_smf1 -- ------------------------------------------------------ -- Server version 4.1.21-standard -- -- Table structure for table `smf_attachments` -- DROP TABLE IF EXISTS `smf_attachments`; CREATE TABLE `smf_attachments` ( `ID_ATTACH` int(10) unsigned NOT NULL auto_increment, `ID_THUMB` int(10) unsigned NOT NULL default '0', `ID_MSG` int(10) unsigned NOT NULL default '0', If it does, then it's a mysql backup file. You can generate a backup from phpmyadmin. Select the database that you want to backup from the dropdown menu. Then click the Export tab. In the area that is titled Exporth, highlight all of the tables that you want a copy of and select SQL from the radio list. In the area that is titled "Save as file", select a compression method. Typically gzip works best for me. Click go, and choose "save file" and click ok.....That should do it for you. __________________ Storage Sheds Lost Forum

04-04-2007, 11:29 AM	#7
roksolana Member Join Date: Mar 2007 Posts: 200	Re: Help.I get .php backup file Thank you, friends. I have just checked it again. My host provider staff tuned phpMyadmin and it generates a correct .sql backup file. Before it was *.php file. Thank you once more. __________________ roksolana-dating.com aMariner.net

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Expload Upload - Free file hosting + File SHARING Website	hemanthjava	Websites for Sale	0	02-25-2007 08:09 AM
Free File Hosting + File Sharing Website	hemanthjava	Websites for Sale	0	02-25-2007 08:08 AM
ps3 backup games	hitachi	General Talk	0	01-31-2007 10:10 PM
Email backup need help	mihail_p	Programming	2	01-22-2007 10:07 AM
Domain Backup ;what is it?	seo	Domain Name	5	12-25-2006 10:08 AM