Joomla Templates Club 406,261 posts

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#189272

Hi,

I need your assistance with issues I am having:
1. I had a website using joomla social. Somehow, my site when off. I have the files before the site went off. And I am switching to a new hosting. Now, when I saved the file, I did not save the database file information. Would it be possible to upload the saved file without the database? If so, how much will you charge me? Please help. Thank you.

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#500307

Hi

Sorry but it’s not completely clear to me what is your issue

could you explain it with more details ?

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#500308

Sure:

I used to have a joomla website. My hosting company no longer exists. I changed hosting company and I have my files from the previous hosting. Unfortunately, when I was copying the files before my website went off, I did not get the database file. So I don’t have the databse information saved when I was copying the files via ftp. I was wondering if you could help to reconstruct the database so that I can load up the files. Let me know if I need to explain more. Thank you very much.

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#500309

Well it’s impossible to reconstruct the database, i mean all the files you saved via ftp are only css php and js files the content for all your website was stored in the various tables of the database – _content table, _user table etc etc

So to make an inverse process starting from files to rebuild a database it’s quite impossible

You need to ask to your old hosting company if they have your .sql file stored as an old backup made on their servers

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#500310

Thank you. I will do that.

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#500368

Sorry for bugging you too much. Would the .sql file look like the one I am attaching here. Please let me know.

<?php
class JConfig {
public $offline = ‘0’;
public $offline_message = ‘Please

Check back Free Africa Foundation within

24 hours.’;
public $display_offline_message =

‘1’;
public $offline_image = ”;
public $sitename = ‘Free Africa

Foundation’;
public $editor = ‘tinymce’;
public $captcha = ‘0’;
public $list_limit = ’20’;
public $access = ‘1’;
public $debug = ‘0’;
public $debug_lang = ‘0’;
public $dbtype = ‘mysqli’;
public $host = ‘localhost’;
public $user =

‘freeafri_etechx1’;
public $password = ‘togo2001’;
public $db = ‘freeafri_africa1’;
public $dbprefix = ‘wgrcf_’;
public $live_site =

‘http://freeafrica.org’;
public $secret =

‘fGcyNRXeubyV3tgU’;
public $gzip = ‘0’;
public $error_reporting =

‘default’;
public $helpurl =

‘http://help.joomla.org/proxy/index.php?

option=com_help&keyref=Help{major}

{minor}:{keyref}’;
public $ftp_host = ‘127.0.0.1’;
public $ftp_port = ’21’;
public $ftp_user = ”;
public $ftp_pass = ”;
public $ftp_root = ”;
public $ftp_enable = ‘0’;
public $offset = ‘UTC’;
public $mailer = ‘mail’;
public $mailfrom =

‘info@freeafrica.org’;
public $fromname = ‘Free Africa

Foundation’;
public $sendmail =

‘/usr/sbin/sendmail’;
public $smtpauth = ‘0’;
public $smtpuser = ”;
public $smtppass = ”;
public $smtphost = ‘localhost’;
public $smtpsecure = ‘none’;
public $smtpport = ’25’;
public $caching = ‘0’;
public $cache_handler = ‘file’;
public $cachetime = ’15’;
public $MetaDesc = ”;
public $MetaKeys = ”;
public $MetaTitle = ‘1’;
public $MetaAuthor = ‘1’;
public $MetaVersion = ‘0’;
public $robots = ”;
public $sef = ‘1’;
public $sef_rewrite = ‘0’;
public $sef_suffix = ‘0’;
public $unicodeslugs = ‘0’;
public $feed_limit = ’10’;
public $log_path =

‘/home/www/final.cheetahgeneration.com/lo

gs’;
public $tmp_path =

‘/home/freeafri/public_html/tmp/’;
public $lifetime = ’15’;
public $session_handler =

‘database’;
public $MetaRights = ”;
public $sitename_pagetitles =

‘0’;
public $force_ssl = ‘0’;
public $feed_email = ‘author’;
public $cookie_domain = ”;
public $cookie_path = ”;
}

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#500370

No

That’s a PHP file

An Sql file is a file with extension .sql and have instructions to insert data in tables if they exists or create them.

Something like this

Database: `DBNAME`
—

— ——————————————————–

—
— TABLENAME `brs6b_acctexp_bucket` brs6b_ = Db prefix acctexp_bucket = table name
—

CREATE TABLE IF NOT EXISTS `brs6b_acctexp_bucket` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject` varchar(255) DEFAULT NULL,
`created_date` datetime DEFAULT ‘0000-00-00 00:00:00’,
`data` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–

—
— Table `brs6b_acctexp_cart`
—

CREATE TABLE IF NOT EXISTS `brs6b_acctexp_cart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT ‘0’,
`created_date` datetime DEFAULT ‘0000-00-00 00:00:00’,
`last_updated` datetime DEFAULT ‘0000-00-00 00:00:00’,
`content` text,
`history` text,
`params` text,
`customparams` text,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–

And so on for all Database tables

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#500371

Thank you. I have all the files from the copy via ftp. I am new to joomla and database. Would it be ok if I send you the files I copied via ftp along with my cpanel information so that you can PLEASE help? I will pay a fee for your work. PLEASE HELP. Thank you

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#500374

You can send me via PM the CPanel details so i can take a look at what you have

[dkabbey Friend dkabbeyJoin date: January 2011Posts: 34Downloads:0Uploads:0 Thanks: 5]

#500375

Thank you. What is your email address?

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#500378

Send it via PM Here click on my name then click on Private Message

[Author]

Posts